This appendix contains sample Accounts Receivable reports
Date 03/30/2019 Time 13:20:19 XYZ Company Report #0070 Page 0001
A / R A C C O U N T S L I S T
Starting account #: “First” Ending account #: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Comments
------------------------------------------------------------------------------------------------------------------------------------
1100-000 Accounts receivable
Primary account for sales.
1110-000 Employee loans receivable
Trade receivables account - long term customers only.
2 A/R accounts on file
-- End of report --
Date 03/30/2019 Time 15:34:00 XYZ Company Report #0071 Page 0001
S H I P - T O A D D R E S S E S
------------------------------------------------------------------------------------------------------------------------------------
Cust Bill-to name Ship-to Ship-to name Description
# Bill-to address # Ship-to address Tax-code Description
Tax exempt #
------------------------------------------------------------------------------------------------------------------------------------
100 Neptune Underwater Supply 1 Neptune Underwater Supply
345 Fisherman’s Pier 1550 S. Coastline Blvd. CNT Taxable Sales L.A. County
Santa Marina, CA 91100 Refugio Beach, CA
91809
437-555-1246
Contact: Audrey Smith Phone: 437-555-1246 Fax: Email:
Oliver Sutton 437-555-1248
2 Neptune Underwater Supply
84 Avalon Way, Suite 12 CNT Taxable Sales L.A. County
Santa Catalina, CA
98809
200 21st Century Enterprises 1 21st Century Enterprises
P.O. Box 4545 P.O. Box 4545 CAL Taxable Sales Cal State
670 Mason Street 670 Mason Street
San Francisco, CA 95782 San Francisco, CA 95782
2 21st Century Enterprises
127 Third St. CAL Taxable Sales Cal State
Palo Alto, CA 97622
4 ship-to addresses on file
-- End of report --
Date 03/30/2019 Time 15:42:59 XYZ Company Report #0072 Page 0001
S H I P V I A C O D E L I S T
------------------------------------------------------------------------------------------------------------------------------------
Ship-via Description
code
------------------------------------------------------------------------------------------------------------------------------------
A Air Freight
P Parcel Post
R Red Line Expres
S Special Courier
T Truck
U UPS
W Will Call
7 codes on file
-- End of report --
Date 03/30/2019 Time 16:10:51 XYZ Company Report #0073 Page 0001
T E R M S C O D E L I S T
EOM = end of current month
------------------------------------------------------------------------------------------------------------------------------------
Terms Description
code
------------------------------------------------------------------------------------------------------------------------------------
Type: Days
Due-days Disc-days Disc-pct
1 2/10 Net 30 30 10 2.00
2 Net 30 30 0 .00
3 5/10 net 25 25 10 5.00
A Normal Terms 30 10 15.00
B Cash 0 0 .00
C Due 25 disc 5 25 5 2.00
Type: Day of next month
Due-day Disc-day Disc-pct Cut-off-day
P Due on the 14th 14th 10th 2.00 EOM
7 terms on file
-- End of report --
Date 03/30/2019 Time 16:55:42 XYZ Company Report #0075 Page 0001
T A X C O D E L I S T
Current period end date: 03/31/19 (PTD totals do not include amounts after this date)
------------------------------------------------------------------------------------------------------------------------------------
Tax Description Total-sales-PTD Misc-charges-PTD Freight-PTD Taxable-amount-PTD Sales-tax-PTD
cod Tax due by Total-sales-YTD Misc-charges-YTD Freight-YTD Taxable-amount-YTD Sales-tax-YTD
------------------------------------------------------------------------------------------------------------------------------------
CAL Taxable Sales Cal State 1,408.10 .00 .00 1,408.10 70.41
Invoice date 1,408.10 .00 .00 1,408.10 70.41
Desc. Acct-# Tx-% On-amt-over T.O.T
1. Tax rate-1 2200-000 5.00 .00
------------------------------------------------------------------------------------------------------------------------------------
CNT Taxable Sales L.A. County 560.25 .00 .00 560.25 28.01
Invoice date 560.25 .00 .00 560.25 28.01
Desc. Acct-# Tx-% On-amt-over T.O.T
1. Tax rate-1 2210-000 5.00 .00
------------------------------------------------------------------------------------------------------------------------------------
CTX County X .00 .00 .00 .00 .00
Invoice date .00 .00 .00 .00 .00
Desc. Acct-# Tx-% On-amt-over T.O.T
1. Tax rate-1 2210-000 7.00 .00
-----------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------
OST Out of State Sales Tax 1,190.00 .00 .00 1,190.00 .00
Invoice date 1,190.00 .00 .00 1,190.00 .00
Desc. Acct-# Tx-% On-amt-over T.O.T
1. Tax rate-1 2200-000 .00 .00
Date 03/30/2019 Time 16:55:42 XYZ Company Report #0075 Page 0002
T A X C O D E L I S T
------------------------------------------------------------------------------------------------------------------------------------
Tax Description Total-sales-PTD Misc-charges-PTD Freight-PTD Taxable-amount-PTD Sales-tax-PTD
cod Tax due by Total-sales-YTD Misc-charges-YTD Freight-YTD Taxable-amount-YTD Sales-tax-YTD
------------------------------------------------------------------------------------------------------------------------------------
6 codes on file
-- End of report --
Date 03/31/2019 Time 11:17:02 XYZ Company Report #0076 Page 0001
C U S T O M E R S B Y C U S T O M E R N U M B E R
Customer # range: “First” to “Last”
For A/R account#: “All”
Balance methods: B = balance forward O = open item
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% POReq
Stm-cyc1 Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord?
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
*401 Miscellaneous customer Scott Fisher 555-777-9100 U Unlimited RET
O OST 0.00 0.000 N
M B 0.00 Y
Y 1st-sale: NONE 1100-000 15A 0.000 Y
Need A/C to dry out store
Lst-Invc-#: SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 0.00 0.00 0.00 Last sale amt: 0.00 NONE
Costs: 0.00 0.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 0.00 0.00 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 0.00 0.00 0.00
QTR1 0.000 0.00 0.00 0.00
**************************************************************************************************************************
1 Elliot Enterprises Paul Elliot 213-779-6010 T Unlimited A WSL
O 123 Broadway CTY 312.44 0.000 N
W Suite 500 B 135.00- Y
Y Glendale CA 94994 1st-sale: 1/25/19 1100-000 1 0.000 Y
Country: USA Regular wholesale terms
Lst-Invc-#: 1018 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 292.00 292.00 0.00 Last sale amt: 292.00 1/25/19
Costs: 77.00 77.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 6.70 6.70 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 312.44 312.44 0.00
QTR1 0.000 312.44 312.44 0.00
Date 03/31/2019 Time 11:17:02 XYZ Company Report #0076 Page 0002
C U S T O M E R S B Y C U S T O M E R N U M B E R
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% POReq
Stm-cyc1 Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord?
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
10 Harris, Goldberg & Jones Michael Jones 714-221-8500 P Unlimited RET
O 456 W. 7th Street CAL 290.22 0.000 N
W Suite 100 A 0.00 Y
Y San Diego CA 92100 1st-sale: 1/25/19 1100-000 1 0.000 Y
Country: USA
Lst-Invc-#: 1019 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 276.40 276.40 0.00 Last sale amt: 276.40 1/25/19
Costs: 77.36 77.36 0.00 Last stmt amt: 0.00 NONE
Commissions: 19.90 19.90 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 300.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 290.22 290.22 0.00
QTR1 0.000 290.22 290.22 0.00
**************************************************************************************************************************
30 W.J. Bjornfreg A/G Mary Kneip 213-886-7722 T Unlimited B WSL
O 1 Wilshire Blvd. CTY 4,825.59- 0.000 N
W Suite 460 1 0.00 Y
Y Los Angeles CA 92100 1st-sale: 1/25/19 1100-000 20 0.000 Y
Lst-Invc-#: 1020 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 163.00 163.00 0.00 Last sale amt: 163.00 1/25/19
Costs: 52.50 52.50 0.00 Last stmt amt: 0.00 NONE
Commissions: 9.78 9.78 0.00 Past due amt: 0.00 NONE
Payments: 5,000.00 5,000.00 0.00 Last pmt amt: 5,000.00 1/30/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 174.41 174.41 5,000.00
QTR1 0.000 174.41 174.41 5,000.00
**************************************************************************************************************************
Date 03/31/2019 Time 11:17:02 XYZ Company Report #0076 Page 0003
C U S T O M E R S B Y C U S T O M E R N U M B E R
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% POReq
Stm-cyc1 Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord?
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
40 Washington, Mrs. Thomas Ann Washington 617-444-7780 P Unlimited A RET
B 350 Hillcrest Circle OST 955.00 0.000 N
W 2 0.00 Y
Y Dallas TX 75201 1st-sale: 1/25/19 1100-000 1 0.000 Y
Country: USA
Lst-Invc-#: 1021 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 955.00 955.00 0.00 Last sale amt: 955.00 1/25/19
Costs: 365.00 365.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 59.00 59.00 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 955.00 955.00 0.00
QTR1 0.000 955.00 955.00 0.00
**************************************************************************************************************************
50 Space Concepts & Design Mike Mallin 212-220-9981 P 20,000 AA RET
O 3901 Ave. of the Americas OST 235.00 0.000 N
W Suite 360 3 0.00 Y
Y New York NY 10052 1st-sale: 1/25/19 1100-000 789 0.000 Y
Country: USA
Lst-Invc-#: 1022 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 235.00 235.00 0.00 Last sale amt: 235.00 1/25/19
Costs: 85.00 85.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 14.10 14.10 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 235.00 235.00 0.00
QTR1 0.000 235.00 235.00 0.00
**************************************************************************************************************************
Date 03/31/2019 Time 11:17:02 XYZ Company Report #0076 Page 0004
C U S T O M E R S B Y C U S T O M E R N U M B E R
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% POReq
Stm-cyc1 Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord?
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
99 Anthony Jones, Inc. T.A. Wagner 123-456-7890 A Unlimited RET
O 15 Winnington Pl. CAL 583.80 0.000 N
M 1 0.00 Y
Y Alberta CA 12345 1st-sale: 1/25/19 1100-000 1 0.000 Y
Country: USA Franchise retailer
Lst-Invc-#: 1023 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 556.00 556.00 0.00 Last sale amt: 556.00 1/25/19
Costs: 156.00 156.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 31.40 31.40 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 583.80 583.80 0.00
QTR1 0.000 583.80 583.80 0.00
100 Neptune Underwater Supply Sam Johnson 408-776-1102 A 25,000 A WSL
O 345 Fisherman’s Pier CNT 88.26 0.000 N
W 2 0.00 Y
Y Santa Marina CA 91100 1st-sale: 1/25/19 1100-000 23 0.000 Y
Country: USA
Lst-Invc-#: 1024 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 560.25 560.25 0.00 Last sale amt: 560.25 1/25/19
Costs: 220.90 220.90 0.00 Last stmt amt: 0.00 NONE
Commissions: 16.81 16.81 0.00 Past due amt: 0.00 NONE
Payments: 500.00 500.00 0.00 Last pmt amt: 500.00 1/29/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 4.000 588.26 588.26 500.00
QTR1 4.000 588.26 588.26 500.00
**************************************************************************************************************************
Date 03/31/2019 Time 11:17:02 XYZ Company Report #0076 Page 0005
C U S T O M E R S B Y C U S T O M E R N U M B E R
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% POReq
Stm-cyc1 Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord?
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
200 21st Century Enterprises Lou Mandel 415-555-7844 P 20,000 AA RET
O P.O. Box 4545 Danny Smith 415-555-7845 CAL 604.49 5.000 N
W 670 Mason Street 3 0.00 Y
Y San Francisco CA 95782 1st-sale: 1/25/19 1100-000 10 2.500 on Price Y
Country: USA Closed vacation Aug 8-20.
Lst-Invc-#: 1025 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 575.70 575.70 0.00 Last sale amt: 575.70 1/25/19
Costs: 138.00 138.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 22.93 22.93 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 604.49 604.49 0.00
QTR1 0.000 604.49 604.49 0.00
**************************************************************************************************************************
300 Beverly Beauty Supply Angie Peters 213-778-9000 T 50,000 AAA RET
B 750 N. Beverely Blvd. CTY 110.40- 0.000 N
2 1 135.00 Y
Y Los Angeles CA 90005 1st-sale: 1/25/19 1100-000 23 0.000 Y
Country: USA
Lst-Invc-#: 1026 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 132.95 132.95 0.00 Last sale amt: 132.95 1/25/19
Costs: 27.00 27.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 3.99 3.99 0.00 Past due amt: 0.00 NONE
Payments: 250.00 250.00 0.00 Last pmt amt: 250.00 1/29/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 142.26 142.26 250.00
QTR1 0.000 142.26 142.26 250.00
**************************************************************************************************************************
Date 03/31/2019 Time 11:17:02 XYZ Company Report #0076 Page 0006
C U S T O M E R S B Y C U S T O M E R N U M B E R
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% POReq
Stm-cyc1 Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord?
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
600 Ariel Enterprises M.J. Thorpe 213-554-4300 U Unlimited RET
B 555 N. Grand Blvd. CTY 561.75 0.000 N
W A 0.00 Y
Y Los Angeles CA 90005 1st-sale: 1/25/19 1100-000 23 0.000 Y
Country: USA
Lst-Invc-#: 1027 SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 525.00 525.00 0.00 Last sale amt: 525.00 1/25/19
Costs: 147.50 147.50 0.00 Last stmt amt: 0.00 NONE
Commissions: 18.26 18.26 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 561.75 561.75 0.00
QTR1 0.000 561.75 561.75 0.00
C123 Peter Cash Peter Cash 123-456-7890 W Unlimited CASH
O 4114 LaSalle CTY 0.00 0.000 N
M B 0.00 Y
N Portland OR 98765-4321 1st-sale: NONE 1100-000 1 5.000 on Price Y
Country: USA
Lst-Invc-#: SIC-code: Sales-Terr: Ship-zone: Credit-hold:
Period-to-date Year-to-date Last-year Date
Sales: 0.00 0.00 0.00 Last sale amt: 0.00 NONE
Costs: 0.00 0.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 0.00 0.00 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------ -------- ------------------- ------------------- -------------------
YTD 0.000 0.00 0.00 0.00
QTR1 0.000 0.00 0.00 0.00
Notes: Date 5/04/97 Time 10:38
Pick up only, no shipping.
12 customers on file 3 balance forward 9 open item
-- End of report --
Date 03/31/2019 Time 11:18:27 XYZ Company Report #0077 Page 0001
C U S T O M E R S B Y C U S T O M E R N A M E
Customer name range: “First” to “Last”
For A/R account#: “All”
Balance methods: B = balance forward O = open item
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
------------------------------------------------------------------------------------------------------------------------------------
200 21st Century Enterprises Lou Mandel 415-555-7844 P 20,000 AA RET
Period-to-date Year-to-date Last-year Date
Sales: 575.70 575.70 0.00 Last sale amt: 575.70 1/25/19
Costs: 138.00 138.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 22.93 22.93 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
99 Anthony Jones, Inc. T.A. Wagner 123-456-7890 A Unlimited RET
Period-to-date Year-to-date Last-year Date
Sales: 556.00 556.00 0.00 Last sale amt: 556.00 1/25/19
Costs: 156.00 156.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 31.40 31.40 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
600 Ariel Enterprises M.J. Thorpe 213-554-4300 U Unlimited RET
Period-to-date Year-to-date Last-year Date
Sales: 525.00 525.00 0.00 Last sale amt: 525.00 1/25/19
Costs: 147.50 147.50 0.00 Last stmt amt: 0.00 NONE
Commissions: 18.26 18.26 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
300 Beverly Beauty Supply Angie Peters 213-778-9000 T 50,000 AAA RET
Period-to-date Year-to-date Last-year Date
Sales: 132.95 132.95 0.00 Last sale amt: 132.95 1/25/19
Costs: 27.00 27.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 3.99 3.99 0.00 Past due amt: 0.00 NONE
Payments: 250.00 250.00 0.00 Last pmt amt: 250.00 1/29/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Date 03/31/2019 Time 11:18:27 XYZ Company Report #0077 Page 0002
C U S T O M E R S B Y C U S T O M E R N A M E
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
------------------------------------------------------------------------------------------------------------------------------------
C123 Peter Cash Peter Cash 123-456-7890 W Unlimited CASH
Period-to-date Year-to-date Last-year Date
Sales: 0.00 0.00 0.00 Last sale amt: 0.00 NONE
Costs: 0.00 0.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 0.00 0.00 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Notes: Date 5/04/97 Time 10:38
Pick up only, no shipping.
**************************************************************************************************************************
1 Elliot Enterprises Paul Elliot 213-779-6010 T Unlimited A WSL
Period-to-date Year-to-date Last-year Date
Sales: 292.00 292.00 0.00 Last sale amt: 292.00 1/25/19
Costs: 77.00 77.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 6.70 6.70 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
10 Harris, Goldberg & Jones Michael Jones 714-221-8500 P Unlimited RET
Period-to-date Year-to-date Last-year Date
Sales: 276.40 276.40 0.00 Last sale amt: 276.40 1/25/19
Costs: 77.36 77.36 0.00 Last stmt amt: 0.00 NONE
Commissions: 19.90 19.90 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 300.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
*401 Miscellaneous customer Scott Fisher 555-777-9100 U Unlimited RET
Period-to-date Year-to-date Last-year Date
Sales: 0.00 0.00 0.00 Last sale amt: 0.00 NONE
Costs: 0.00 0.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 0.00 0.00 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Date 03/31/2019 Time 11:18:27 XYZ Company Report #0077 Page 0003
C U S T O M E R S B Y C U S T O M E R N A M E
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
------------------------------------------------------------------------------------------------------------------------------------
100 Neptune Underwater Supply Sam Johnson 408-776-1102 A 25,000 A WSL
Period-to-date Year-to-date Last-year Date
Sales: 560.25 560.25 0.00 Last sale amt: 560.25 1/25/19
Costs: 220.90 220.90 0.00 Last stmt amt: 0.00 NONE
Commissions: 16.81 16.81 0.00 Past due amt: 0.00 NONE
Payments: 500.00 500.00 0.00 Last pmt amt: 500.00 1/29/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
50 Space Concepts & Design Mike Mallin 212-220-9981 P 20,000 AA RET
Period-to-date Year-to-date Last-year Date
Sales: 235.00 235.00 0.00 Last sale amt: 235.00 1/25/19
Costs: 85.00 85.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 14.10 14.10 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
30 W.J. Bjornfreg A/G Mary Kneip 213-886-7722 T Unlimited B WSL
Period-to-date Year-to-date Last-year Date
Sales: 163.00 163.00 0.00 Last sale amt: 163.00 1/25/19
Costs: 52.50 52.50 0.00 Last stmt amt: 0.00 NONE
Commissions: 9.78 9.78 0.00 Past due amt: 0.00 NONE
Payments: 5,000.00 5,000.00 0.00 Last pmt amt: 5,000.00 1/30/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
**************************************************************************************************************************
40 Washington, Mrs. Thomas Ann Washington 617-444-7780 P Unlimited A RET
Period-to-date Year-to-date Last-year Date
Sales: 955.00 955.00 0.00 Last sale amt: 955.00 1/25/19
Costs: 365.00 365.00 0.00 Last stmt amt: 0.00 NONE
Commissions: 59.00 59.00 0.00 Past due amt: 0.00 NONE
Payments: 0.00 0.00 0.00 Last pmt amt: 0.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
12 customers on file 3 balance forward 9 open item
-- End of report --
Date 03/31/2019 Time 11:36:35 XYZ Company Report #0079 Page 0001
C U S T O M E R C H A N G E L O G
Balance methods: B = balance forward O = open item
Information underlined with “*” has changed
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% Cr Hld
Stm-cycl Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord? POReq
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
10 Harris, Goldberg & Jones Michael Jones 714-221-8500 P Unlimited RET
O 456 W. 7th Street CAL 290.22 0.000
W Suite 100 A 0.00 Y N
Y San Diego CA 92100 1st-sale: 1/25/19 1100-000 1 0.000 on Price Y
Country: USA
SIC-code: Sls-Terr: Ship-Zone: Lst-Invc-#: 1019 Pst-Due-Amt: 0.00 Pst-Due-Calc-Dat: NONE
Period-to-date Year-to-date Last-year Date
Sales: 276.40 276.40 0.00 Last sale amt: 276.40 1/25/19
Costs: 77.36 77.36 0.00 Last stmt amt: 0.00 NONE
Commissions: 19.90 19.90 0.00
Payments: 0.00 0.00 0.00 Last pmt amt: 300.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
---------- -------- ------------------- ------------------- -------------------
Curr Prd 0.000 290.22 290.22 0.00
changed by: RWA on 03/31/19 to become
10 Harris, Goldberg & Jones Michael Jones 714-221-8500 P Unlimited RET
O 456 W. 7th Street CAL 290.22 0.000
W Suite 100 A 0.00 Y N
Y San Diego CA 92100 1st-sale: 1/25/19 1100-000 10 0.000 on Price Y
***
Country: USA
SIC-code: Sls-Terr: Ship-Zone: Lst-Invc-#: 1019 Pst-Due-Amt: 0.00 Pst-Due-Calc-Dat: NONE
Period-to-date Year-to-date Last-year Date
Sales: 276.40 276.40 0.00 Last sale amt: 276.40 1/25/19
Costs: 77.36 77.36 0.00 Last stmt amt: 0.00 NONE
Commissions: 19.90 19.90 0.00
Payments: 0.00 0.00 0.00 Last pmt amt: 300.00 NONE
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
---------- -------- ------------------- ------------------- -------------------
Curr Prd 0.000 290.22 290.22 0.00
------------------------------------------------------------------------------------------------------------------------------------
Date 03/31/2019 Time 11:36:35 XYZ Company Report #0079 Page 0002
C U S T O M E R C H A N G E L O G
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Contact-1 Phone-1 Shp-via Credit-limit Crd-rte Type
Bal-mth Address-1 Contact-2 Phone-2 Tax-cod Account-balance Disc-% Cr Hld
Stm-cycl Address-2 Comment Tax-exempt-# Terms Unpostd-balance Bk-ord? POReq
Fin-chg? City, St, Zip A/R-account-# Sls-rep Commission-pct Pt-shp?
------------------------------------------------------------------------------------------------------------------------------------
30 W.J. Bjornfreg A/G Mary Kneip 213-886-7722 T Unlimited B WSL
O 1 Wilshire Blvd. CTY 4,825.59- 0.000
W Suite 460 1 0.00 Y N
Y Los Angeles CA 92100 1st-sale: 1/25/19 1100-000 20 0.000 on Price Y
Country:
SIC-code: Sls-Terr: Ship-Zone: Lst-Invc-#: 1020 Pst-Due-Amt: 0.00 Pst-Due-Calc-Dat: NONE
Period-to-date Year-to-date Last-year Date
Sales: 163.00 163.00 0.00 Last sale amt: 163.00 1/25/19
Costs: 52.50 52.50 0.00 Last stmt amt: 0.00 NONE
Commissions: 9.78 9.78 0.00
Payments: 5,000.00 5,000.00 0.00 Last pmt amt: 5,000.00 1/30/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
---------- -------- ------------------- ------------------- -------------------
Curr Prd 0.000 174.41 174.41 5,000.00
changed by: RWA on 03/31/19 to become
30 W.J. Bjornfreg A/G MaryAnne Knopf 213-886-7722 T Unlimited B WSL
*************************
O 1 Wilshire Blvd. CTY 4,825.59- 0.000
W Suite 460 1 0.00 Y N
Y Los Angeles CA 92100 1st-sale: 1/25/19 1100-000 20 0.000 on Price Y
Country:
SIC-code: Sls-Terr: Ship-Zone: Lst-Invc-#: 1020 Pst-Due-Amt: 0.00 Pst-Due-Calc-Dat: NONE
Period-to-date Year-to-date Last-year Date
Sales: 163.00 163.00 0.00 Last sale amt: 163.00 1/25/19
Costs: 52.50 52.50 0.00 Last stmt amt: 0.00 NONE
Commissions: 9.78 9.78 0.00
Payments: 5,000.00 5,000.00 0.00 Last pmt amt: 5,000.00 1/30/19
Fin charges: 0.00 0.00 0.00 Last fin chg amt: 0.00 NONE
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
---------- -------- ------------------- ------------------- -------------------
Curr Prd 0.000 174.41 174.41 5,000.00
------------------------------------------------------------------------------------------------------------------------------------
2 Changes on file
-- End of report --
Date 03/31/2019 Time 12:01:20 XYZ Company Report #0080 Page 0001
G O O D S L I S T
Starting item number: “First”
Ending item number: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Item-# Unit Price Cost Description
------------------------------------------------------------------------------------------------------------------------------------
1 EACH 0.00000 0.00000 Miscellaneous sales
2 FT. 3.55000 1.75000 Air conditioning hose
3 EACH 65.00000 45.00000 Support bracketing custom metal framing
15MW LNFT 0.08500 0.02500 15 mil insulated wire (red insulation)
4 Items on file
-- End of report --
Date 03/31/2019 Time 12:05:41 XYZ Company Report #0081 Page 0001
S E R V I C E S L I S T
Starting service number: “First”
Ending service number: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Service-# Unit Price Cost Description
------------------------------------------------------------------------------------------------------------------------------------
1 HOUR 50.00000 25.00000 Primary installation
2 (None) 400.00000 150.00000 1 year service and maintenance
3 HOUR 35.00000 19.00000 Survey and estimate
4 HOUR 10.00000 6.50000 Monthly check & services
5 HOUR 16.00000 9.00000 Clean, lubricate, change filters & belts
5 Services on file
-- End of report --
Date 03/31/2019 Time 15:45:59 XYZ Company Report #0082 Page 0001
V E R I F Y R E P O R T
Format: 11 Example format
Number of rows: 66 Line items start at row: 28 Max # of rows per line item: 5
Number of columns: 80 Line items end at row: 57 Starting row of total area: Just after items
** HEADER FIELDS **
No HEADER field errors
** LINE ITEM FIELDS **
No LINE ITEM field errors
** TOTAL FIELDS **
No TOTAL field errors
*** Invoice format verified ***
-- End of report --
Date 04/02/2019 Time 11:53:08 XYZ Company Report #0083 Page 0001
V E R I F Y S T A T E M E N T F O R M A T
Format: 2 Stmt with closing area
Number of rows: 66 First page open items start at row: 16 Open items for additional pages start at row: 8
Number of columns: 80 First page open items end at row: 59 Open items for additional pages end at row: 59
First page footer starts at row: 60 Footer for additional pages start at row: 60
** HEADER FIRST PAGE FIELDS **
No HEADER FIRST PAGE field errors
** HEADER ADDITIONAL PAGES FIELDS **
No HEADER ADDITIONAL PAGES field errors
** CLOSING FIELDS **
Field: Aging period 1 amount - Number of integers specified less than maximum allowed (Warning only)
Less than 4 aging period amounts found - (Warning only)
No CLOSING field errors
** FOOTER FIRST PAGE FIELDS **
No FOOTER FIRST PAGE FIELDS found - (Warning only)
No FOOTER FIRST PAGE field errors
** FOOTER ADDITIONAL PAGES FIELDS **
No FOOTER ADDITIONAL PAGES FIELDS found - (Warning only)
No FOOTER ADDITIONAL PAGES field errors
*** Statement format verified ***
-- End of report --
Statement Format Specification
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0001
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
------------------------------------------------------------------------------------------------------------------------------------
Format: 1 v6.X Format 1 (verified)
------------------------------------------------------------------------------------------------------------------------------------
** GENERAL APPEARANCE **
Number of rows: 51
Number of columns: 80
Open item format ? v6 A/R format 1 --------- First page ----------
Starting column for open items: 3 First row of open item area: 17
Skip a row between open items ? N Last row of open item area: 40
Start or end open items with a line: None
Kind of line: N/A ------ Additional pages -------
# of rows in stmnt closing area: 6 First row of open item area: 17
Min # open items to print on last pg: 1 Last row of open item area: 40
------------------------------------------------------------------------------------------------------------------------------------
** HEADER FIELDS, FIRST PAGE **
-------Field description-------- Row Col Type Length Format
Your company name 1 8 Alpha 30 Justify left
Your company address line 1 2 8 Alpha 30 Justify left
Your company address line 2 3 8 Alpha 30 Justify left
Statement date 3 44 Date 8 09/30/19
Your company address line 3 4 8 Alpha 30 Justify left
** TEXT ** 5 8 Text 9 Telephone
Your telephone number 5 18 Alpha 12 Justify left
Customer number 7 41 Alpha 12 Justify left
Customer name 7 56 Alpha 25 Justify left
Customer name 8 8 Alpha 25 Justify left
Customer address line 1 9 8 Alpha 25 Justify left
Customer address line 2 10 8 Alpha 25 Justify left
Customer city, state zip-code 11 8 Alpha 30 Justify left
Statement date 11 57 Date 8 09/30/19
Customer number 11 68 Alpha 12 Justify left
Customer country 12 8 Alpha 25 Justify left
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0002
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
-------------------------------------------------------------------------------------------------Format: 1 v6.X Format 1 (verified)
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, ADDITIONAL PAGES **
-------Field description-------- Row Col Type Length Format
Your company name 1 8 Alpha 30 Justify left
Your company address line 1 2 8 Alpha 30 Justify left
Your company address line 2 3 8 Alpha 30 Justify left
Statement date 3 42 Date 8 09/30/19
Your company address line 3 4 8 Alpha 30 Justify left
** TEXT ** 5 8 Text 9 Telephone
Your telephone number 5 18 Alpha 12 Justify left
Customer number 7 39 Alpha 12 Justify left
Customer name 7 54 Alpha 25 Justify left
Customer name 8 8 Alpha 25 Justify left
Customer address line 1 9 8 Alpha 25 Justify left
Customer address line 2 10 8 Alpha 25 Justify left
Customer city, state zip-code 11 8 Alpha 30 Justify left
Statement date 11 55 Date 8 09/30/19
Customer number 11 66 Alpha 12 Justify left
Customer country 12 8 Alpha 25 Justify left
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0003
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
-------------------------------------------------------------------------------------------------Format: 2 Stmt with closing area (verified)
-------------------------------------------------------------------------------------------------
** GENERAL APPEARANCE **
Number of rows: 66
Number of columns: 80
Open item format ? Brief --------- First page ----------
Starting column for open items: Centered First row of open item area: 16
Skip a row between open items ? N Last row of open item area: 59
Start or end open items with a line: Both start and end
Kind of line: Dashed line ------ Additional pages -------
# of rows in stmnt closing area: 5 First row of open item area: 8
Min # open items to print on last pg: 1 Last row of open item area: 59
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, FIRST PAGE **
-------Field description-------- Row Col Type Length Format
Statement date 6 53 Date 18 September 30, 1999
Customer name 12 11 Alpha 25 Justify left
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, ADDITIONAL PAGES **
-------Field description-------- Row Col Type Length Format
** TEXT ** 5 60 Text 4 Page
Page number 5 69 Num 2 99
-------------------------------------------------------------------------------------------------
** STATEMENT CLOSING FIELDS **
-------Field description-------- Row Col Type Length Format
Aging period 1 amount 4 12 Num 14 99,999,999.99-
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0004
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
-------------------------------------------------------------------------------------------------Format: 3 Predefined statement # 1 (verified)
Number of rows: 59
Number of columns: 80
Open item format ? Brief --------- First page ----------
Starting column for open items: Centered First row of open item area: 16
Skip a row between open items ? N Last row of open item area: 56
Start or end open items with a line: Both start and end
Kind of line: Dashed line ------ Additional pages -------
# of rows in stmnt closing area: 5 First row of open item area: 8
Min # open items to print on last pg: 1 Last row of open item area: 56
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, FIRST PAGE **
-------Field description-------- Row Col Type Length Format
Statement date 6 53 Date 18 September 30, 1999
Your company name 8 41 Alpha 30 Justify left
Your company address line 1 9 41 Alpha 30 Justify left
Your company address line 2 10 41 Alpha 30 Justify left
Your company address line 3 11 41 Alpha 30 Justify left
Customer name 12 11 Alpha 25 Justify left
Customer address line 1 13 11 Alpha 25 Justify left
Customer address line 2 14 11 Alpha 25 Justify left
Customer city, state zip-code 15 11 Alpha 30 Justify left
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, ADDITIONAL PAGES **
-------Field description-------- Row Col Type Length Format
Statement date 6 53 Date 18 September 30, 1999
-------------------------------------------------------------------------------------------------
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0005
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
-------------------------------------------------------------------------------------------------Format: 3 Predefined statement # 1 (verified)
-------------------------------------------------------------------------------------------------
** FOOTER FIELDS, FIRST PAGE **
-------Field description-------- Row Col Type Length Format
** TEXT ** 58 35 Text 4 Page
Page number 58 40 Num 2 99
-------------------------------------------------------------------------------------------------
** FOOTER FIELDS, ADDITIONAL PAGES **
-------Field description-------- Row Col Type Length Format
Your company name 58 10 Alpha 30 Justify left
Your company address line 1 58 41 Alpha 30 Justify left
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0006
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
-------------------------------------------------------------------------------------------------Format: 4 Predefined statement # 2 (verified)
-------------------------------------------------------------------------------------------------
** GENERAL APPEARANCE **
Number of rows: 59
Number of columns: 80
Open item format ? Brief --------- First page ----------
Starting column for open items: Centered First row of open item area: 16
Skip a row between open items ? N Last row of open item area: 56
Start or end open items with a line: Both start and end
Kind of line: Dashed line ------ Additional pages -------
# of rows in stmnt closing area: 5 First row of open item area: 8
Min # open items to print on last pg: 1 Last row of open item area: 56
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, FIRST PAGE **
-------Field description-------- Row Col Type Length Format
Statement date 6 53 Date 18 September 30, 1999
Your company name 8 41 Alpha 30 Justify left
Your company address line 1 9 41 Alpha 30 Justify left
Your company address line 2 10 41 Alpha 30 Justify left
Your company address line 3 11 41 Alpha 30 Justify left
Customer name 12 11 Alpha 25 Justify left
Customer address line 1 13 11 Alpha 25 Justify left
Customer address line 2 14 11 Alpha 25 Justify left
Customer city, state zip-code 15 11 Alpha 30 Justify left
-------------------------------------------------------------------------------------------------
** HEADER FIELDS, ADDITIONAL PAGES **
-------Field description-------- Row Col Type Length Format
Statement date 6 53 Date 18 September 30, 1999
-------------------------------------------------------------------------------------------------
Date 04/02/2019 Time 14:48:34 XYZ Company Report #0084 Page 0007
S T A T E M E N T F O R M A T S P E C I F I C A T I O N S
-------------------------------------------------------------------------------------------------Format: 4 Predefined statement # 2 (verified)
** STATEMENT CLOSING FIELDS **
-------Field description-------- Row Col Type Length Format
Aging period 1 description 1 2 12 Alpha 13 Justify left
Aging period 2 description 1 2 27 Alpha 13 Justify left
Aging period 3 description 1 2 42 Alpha 13 Justify left
Aging period 4 description 1 2 57 Alpha 13 Justify left
Aging period 1 description 2 3 12 Alpha 13 Justify left
Aging period 2 description 2 3 27 Alpha 13 Justify left
Aging period 3 description 2 3 42 Alpha 13 Justify left
Aging period 4 description 2 3 57 Alpha 13 Justify left
Aging period 1 amount 4 12 Num 14 99,999,999.99-
Aging period 2 amount 4 27 Num 14 99,999,999.99-
Aging period 3 amount 4 42 Num 14 99,999,999.99-
Aging period 4 amount 4 57 Num 14 99,999,999.99-
** FOOTER FIELDS, FIRST PAGE **
-------Field description-------- Row Col Type Length Format
** TEXT ** 58 35 Text 4 Page
Page number 58 40 Num 2 99
-------------------------------------------------------------------------------------------------
** FOOTER FIELDS, ADDITIONAL PAGES **
-------Field description-------- Row Col Type Length Format
Your company name 58 10 Alpha 30 Justify left
Your company address line 1 58 41 Alpha 30 Justify left
-- End of report --
Date 04/02/2019 Time 15:04:44 XYZ Company Report #0085 Page 0001
I N V O I C I N G S T A T I O N S L I S T
------------------------------------------------------------------------------------------------------------------------------------
Station Description Printer Next Invc Description
code Invc-# Fmt
------------------------------------------------------------------------------------------------------------------------------------
1 Retail desk PRINTER 1 100003 1 Pre-printed Form (Goods)
2 Phone desk A Office Printer 200002 1 Pre-printed Form (Goods)
3 Phone desk B PRINTER 1 300002 2 Open form (Goods & Serv)
4 Phone desk C Office Printer 400000 2 Open form (Goods & Serv)
4 stations on file
-- End of report --
Date 04/02/2019 Time 15:21:10 XYZ Company Report #0086 Page 0001
P R I N T E R C O N T R O L L I S T
------------------------------------------------------------------------------------------------------------------------------------
Prtr-# Name Device Description Form type
Control-code
------------------------------------------------------------------------------------------------------------------------------------
1 PRINTER 1 HP Laserjet, manual envelope Cut sheets # envelope rows: 24 Address row: 11
HP1 Envelopes? Yes Unprintable-lines Top: 3 Bottom: 3 # envelope cols: 95 Address col: 35
---------------- Control codes ---------------------------------------------- Return address row: 2
Return address col: 2
Print job control
Reset start: 1B451B266C336532613664304C Return address:
Feeder on: RETURN ADDRESS LINE 1--------!
Letter mode: RETURN ADDRESS LINE 2--------!
Draft mode: RETURN ADDRESS LINE 3--------!
Feeder off: RETURN ADDRESS LINE 4--------!
Reset end: 1B45
Paper source selection
1st page bin: 1B266C31683055 Orientation: Portrait
2nd page bin: Orientation: None specified
Envelope bin: Orientation: Landscape
Portrait: 1B266C304F
Landscape: 1B266C314F
Get page:
Eject page: 0C
=========================================================================================================================
1 PRINTER 1 Laserjet D, envelope feeder Cut sheets # envelope rows: 24 Address row: 11
HP2 Envelopes? Yes Unprintable-lines Top: 3 Bottom: 3 # envelope cols: 95 Address col: 35
---------------- Control codes ---------------------------------------------- Return address row: 2
Return address col: 2
Print job control
Reset start: 1B451B266C336532613664304C Return address:
Feeder on: RETURN ADDRESS LINE 1--------!
Letter mode: RETURN ADDRESS LINE 2--------!
Draft mode: RETURN ADDRESS LINE 3--------!
Feeder off: RETURN ADDRESS LINE 4--------!
Reset end: 1B45
Paper source selection
1st page bin: 1B266C31683055 Orientation: Portrait
2nd page bin: 1B266C34683055 Orientation: Portrait
Envelope bin: 1B266C34683055 Orientation: Landscape
Portrait: 1B266C304F
Landscape: 1B266C314F
Get page:
Eject page: 0C
Date 04/02/2019 Time 15:21:10 XYZ Company Report #0086 Page 0002
P R I N T E R C O N T R O L L I S T
------------------------------------------------------------------------------------------------------------------------------------
Prtr-# Name Device Description Form type
Control-code
------------------------------------------------------------------------------------------------------------------------------------
1 PRINTER 1 IBM Proprinter Continuous
IBM1 Envelopes? No
---------------- Control codes ----------------------------------------------
Print job control
Reset start:
Feeder on:
Letter mode: 1B47
Draft mode: 1B48
Feeder off:
Reset end:
=========================================================================================================================
1 PRINTER 1 Tandy LP950, single bin Cut sheets
LP950 Envelopes? No Unprintable-lines Top: 3 Bottom: 3
---------------- Control codes ----------------------------------------------
Print job control
Reset start: 1B451B266C33451B266C3636501B26
Feeder on:
Letter mode:
Draft mode:
Feeder off:
Reset end: 1B45
Paper source selection
1st page bin: 1B266C3148 Orientation: Portrait
2nd page bin: Orientation: None specified
Envelope bin: Envelopes are not printed
Portrait: 1B266C304F
Landscape: 1B266C314F
Get page:
Eject page: 0C
=========================================================================================================================
1 PRINTER 1 Epson LQ, continuous forms Continuous # envelope rows: 24 Address row: 12
LQ1 Envelopes? Yes # envelope cols: 95 Address col: 35
---------------- Control codes ---------------------------------------------- Return address row: 0
Print job control
Reset start: 1B40
Feeder on:
Letter mode: 1B7801
Draft mode: 1B7800
Feeder off:
Reset end: 1B40
Date 04/02/2019 Time 15:21:11 XYZ Company Report #0086 Page 0003
P R I N T E R C O N T R O L L I S T
-------------------------------------------------------------------------------------------------Prtr-# Name Device Description Form type
Control-code
-------------------------------------------------------------------------------------------------
1 PRINTER 1 Epson LQ, dual cut sheet bins Cut sheets
LQ2 Envelopes? No Unprintable-lines Top: 2 Bottom: 3
---------------- Control codes ----------------------------------------------
Print job control
Reset start: 1B40
Feeder on:
Letter mode: 1B7801
Draft mode: 1B7800
Feeder off:
Reset end: 1B40
Paper source selection
1st page bin: 1B1931 Orientation: None specified
2nd page bin: 1B1932 Orientation: None specified
Envelope bin: Envelopes are not printed
Portrait:
Landscape:
Get page: 0C
Eject page: 0C
-- End of report --
Date 04/02/2019 Time 15:44:31 XYZ Company Report #0087 Page 0001
A / R O P E N I T E M F I L E E D I T L I S T
Document types: I = invoice P = payment C = credit memo D = debit memo F = finance charge B = balance forward R = returned check
Note: Amount-1 is the amount subject to discount, on doc types I, C, D, B & R; cash receipt amt on type P; fin charge on type F.
Amount-2 is the non-discountable amt on doc types I,C,D & R; discount allowed on doc type P; and not used for doc types B & F.
------------------------------------------------------------------------------------------------------------------------------------
------Document------ Apply Trm Due Amount-1 Amount-2 Document P.O.-# Reference
# date typ to-# cod date total
------------------------------------------------------------------------------------------------------------------------------------
Customer: 1 Elliot Enterprises
------------------------------------------
1018 01/25/19 I 1018 B 01/25/19 292.00 20.44 312.44 From O/E order: 000032
Customer 1 totals: 292.00 20.44 312.44
Customer: 10 Harris, Goldberg & Jones
------------------------------------------------
1019 01/25/19 I 1019 A 02/24/19 276.40 13.82 290.22 From O/E order: 000033
Customer 10 totals: 276.40 13.82 290.22
Customer: 30 W.J. Bjornfreg A/G
------------------------------------------
1020 01/25/19 I 1020 1 02/24/19 163.00 11.41 174.41 From O/E order: 000034
1359 01/30/19 P Open 1 01/30/19 5,000.00- 0.00 5,000.00- Pre-Payment for Future
Customer 30 totals: 4,837.00- 11.41 4,825.59-
Customer: 40 Washington, Mrs. Thomas
-----------------------------------------------
1021 01/25/19 I 1021 2 02/24/19 955.00 0.00 955.00 From O/E order: 000035
Customer 40 totals: 955.00 0.00 955.00
Customer: 50 Space Concepts & Design
-----------------------------------------------
1022 01/25/19 I 1022 3 02/19/19 235.00 0.00 235.00 From O/E order: 000036
Customer 50 totals: 235.00 0.00 235.00
Customer: 99 Anthony Jones, Inc.
-------------------------------------------
1023 01/25/19 I 1023 1 02/24/19 556.00 27.80 583.80 From O/E order: 000037
Customer 99 totals: 556.00 27.80 583.80
Customer: 100 Neptune Underwater Supply
-------------------------------------------------
Date 04/02/2019 Time 15:44:31 XYZ Company Report #0087 Page 0002
A / R O P E N I T E M F I L E E D I T L I S T
-------------------------------------------------------------------------------------------------------Document------ Apply Trm Due Amount-1 Amount-2 Document P.O.-# Reference
# date typ to-# cod date total
-------------------------------------------------------------------------------------------------
Customer: 100 Neptune Underwater Supply
1024 01/25/19 I 1024 2 02/24/19 560.25 28.01 588.26 From O/E order: 000038
1001 01/29/19 P 1024 3 01/29/19 500.00- 0.00 500.00-
Customer 100 totals: 60.25 28.01 88.26
Customer: 200 21st Century Enterprises
------------------------------------------------
1025 01/25/19 I 1025 3 02/19/19 575.70 28.79 604.49 From O/E order: 000039
3002 03/03/19 I 3002 3 03/28/19 715.45 69.42 784.87 Regular purchase
Customer 200 totals: 1,291.15 98.21 1,389.36
Customer: 300 Beverly Beauty Supply
---------------------------------------------
1026 01/25/19 I 1026 1 02/24/19 132.95 9.31 142.26 From O/E order: 000040
*Cash* 01/29/19 P A 01/29/19 250.00- 2.66- 252.66-
Customer 300 totals: 117.05- 6.65 110.40-
Customer: 600 Ariel Enterprises
-----------------------------------------
1027 01/25/19 I 1027 A 02/24/19 525.00 36.75 561.75 From O/E order: 000041
Customer 600 totals: 525.00 36.75 561.75
-- End of report --
Date 04/05/2019 Time 12:49:28 XYZ Company Report #0088 Page 0001
C A S H R E C E I P T S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
100 Neptune Underwater Supply OPEN-ITEM 03/10/19 201 140.00 1000-000
Bank route #: 125-6992 Cash account #13557
Apply-to Amt-paid Discount Allowance Total-applied All-acct Reference
Open 140.00 0.00 0.00 140.00
200 21st Century Enterprises OPEN-ITEM 03/12/19 348 1,500.00 1000-000
Bank route #: 125-6992 Cash account #13557
Amt-credited Credited-to
1,500.00 4040-000 Misc. charges on sales
200 21st Century Enterprises OPEN-ITEM 03/12/19 349 500.00 1000-000
Bank route #: 125-6992 Cash account #13557
Apply-to Amt-paid Discount Allowance Total-applied All-acct Reference
1025 500.00 0.00 0.00 500.00
300 Beverly Beauty Supply BAL-FORWD 03/12/19 349 1,500.00 1000-000
Bank route #: 125-6992 Cash account #13557
Discount Allowance Total-credited Allowance-account
0.00 250.00 1,750.00 4060-000 Sales allowances
Date 04/05/2019 Time 12:49:28 XYZ Company Report #0088 Page 0002
C A S H R E C E I P T S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
4 Entries Grand totals:
-------------
Amount received: 3,640.00
Discounts allowed: 0.00
Allowances: 250.00
Total credited: 3,890.00
Total credited to A/R: 2,390.00
Total other credited: 1,500.00
Cash accounts: Debits Credits Checks Cash
1000-000 Cash account #13557 3,640.00 0.00 3,640.00 0.00
------------------ ------------------ ------------------ ------------------
Totals for cash accounts: 3,640.00 0.00 3,640.00 0.00
A/R accounts:
1100-000 Accounts receivable 0.00 2,390.00
--------------------- ---------------------
Totals for A/R accounts: 0.00 2,390.00
All other accounts:
4040-000 Misc. charges on sales 0.00 1,500.00
4060-000 Sales allowances 250.00 0.00
--------------------- ---------------------
Totals for all other accounts: 250.00 1,500.00
Totals for all accounts: 3,890.00 3,890.00
-- End of report --
Date 04/05/2019 Time 12:52:30 XYZ Company Report #0091 Page 0001
C A S H R E C E I P T S J O U R N A L
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
100 Neptune Underwater Supply OPEN-ITEM 03/10/19 201 140.00 1000-000
Bank route #: 125-6992 Cash account #13557
Apply-to Amt-paid Discount Allowance Total-applied All-acct Reference
Open 140.00 0.00 0.00 140.00
200 21st Century Enterprises OPEN-ITEM 03/12/19 348 1,500.00 1000-000
Bank route #: 125-6992 Cash account #13557
Amt-credited Credited-to
1,500.00 4040-000 Misc. charges on sales
200 21st Century Enterprises OPEN-ITEM 03/12/19 349 500.00 1000-000
Bank route #: 125-6992 Cash account #13557
Apply-to Amt-paid Discount Allowance Total-applied All-acct Reference
1025 500.00 0.00 0.00 500.00
300 Beverly Beauty Supply BAL-FORWD 03/12/19 349 1,500.00 1000-000
Bank route #: 125-6992 Cash account #13557
Discount Allowance Total-credited Allowance-account
0.00 250.00 1,750.00 4060-000 Sales allowances
Date 04/05/2019 Time 12:52:30 XYZ Company Report #0091 Page 0002
C A S H R E C E I P T S J O U R N A L
-------------------------------------------------------------------------------------------------Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
-------------------------------------------------------------------------------------------------
4 Entries Grand totals:
-------------
Amount received: 3,640.00
Discounts allowed: 0.00
Allowances: 250.00
Total credited: 3,890.00
Total credited to A/R: 2,390.00
Total other credited: 1,500.00
Cash accounts: Debits Credits Checks Cash
1000-000 Cash account #13557 3,640.00 0.00 3,640.00 0.00
------------------ ------------------ ------------------ ------------------
Totals for cash accounts: 3,640.00 0.00 3,640.00 0.00
A/R accounts:
1100-000 Accounts receivable 0.00 2,390.00
--------------------- ---------------------
Totals for A/R accounts: 0.00 2,390.00
All other accounts:
4040-000 Misc. charges on sales 0.00 1,500.00
4060-000 Sales allowances 250.00 0.00
--------------------- ---------------------
Totals for all other accounts: 250.00 1,500.00
Totals for all accounts: 3,890.00 3,890.00
-- End of report --
Date 04/05/2019 Time 13:36:50 XYZ Company Report #0092 Page 0001
C A S H A P P L I C A T I O N W O R K S H E E T
For all customers
Cash receipt date: 3/30/19
“*” next to discount means the terms for this open item are not the standard terms
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance Terms Receipt
Address-1 Method Date
------------------------------------------------------------------------------------------------------------------------------------
1 Elliot Enterprises OPEN-ITEM Cash 3/30/19 Check #: _________ Ref: _________________________
123 Broadway
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1018 1/25/19 1/25/19 312.44 0.00 312.44
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 312.44 0.00 312.44
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
====================================================================================================================================
10 Harris, Goldberg & Jones OPEN-ITEM Normal Terms 3/30/19 Check #: _________ Ref: _________________________
456 W. 7th Street
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1019 1/25/19 2/24/19 290.22 0.00 290.22
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 290.22 0.00 290.22
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
====================================================================================================================================
30 W.J. Bjornfreg A/G OPEN-ITEM 2/10 Net 30 3/30/19 Check #: _________ Ref: _________________________
1 Wilshire Blvd.
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
**OPEN** 1/30/19 1/30/19 5,000.00- 0.00 0.00
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1020 1/25/19 2/24/19 174.41 0.00 174.41
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 4,825.59- 0.00 174.41
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
Date 04/05/2019 Time 13:36:50 XYZ Company Report #0092 Page 0002
C A S H A P P L I C A T I O N W O R K S H E E T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance Terms Receipt
Address-1 Method Date
------------------------------------------------------------------------------------------------------------------------------------
40 Washington, Mrs. Thomas BAL-FORWD Net 30 3/30/19 Check #: _________ Ref: _________________________
350 Hillcrest Circle
Balance Valid-disc Cash-due
Customer totals: 955.00 0.00 955.00
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
====================================================================================================================================
50 Space Concepts & Design OPEN-ITEM 5/10 net 25 3/30/19 Check #: _________ Ref: _________________________
3901 Ave. of the Americas
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1022 1/25/19 2/19/19 235.00 0.00 235.00
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 235.00 0.00 235.00
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
====================================================================================================================================
99 Anthony Jones, Inc. OPEN-ITEM 2/10 Net 30 3/30/19 Check #: _________ Ref: _________________________
15 Winnington Pl.
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1023 1/25/19 2/24/19 583.80 0.00 583.80
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 583.80 0.00 583.80
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
====================================================================================================================================
100 Neptune Underwater Supply OPEN-ITEM Net 30 3/30/19 Check #: _________ Ref: _________________________
345 Fisherman’s Pier
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
**OPEN** 3/10/19 3/10/19 140.00- 0.00 0.00
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Date 04/05/2019 Time 13:36:50 XYZ Company Report #0092 Page 0003
C A S H A P P L I C A T I O N W O R K S H E E T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance Terms Receipt
Address-1 Method Date
------------------------------------------------------------------------------------------------------------------------------------
100 (Continued)
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1024 1/25/19 2/24/19 88.26 0.00 88.26
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 51.74- 0.00 88.26
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
====================================================================================================================================
200 21st Century Enterprises OPEN-ITEM 5/10 net 25 3/30/19 Check #: _________ Ref: _________________________
P.O. Box 4545
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
1025 1/25/19 2/19/19 104.49 0.00 104.49
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Apply-to Doc-date Due-date Balance Valid-disc Cash-due
3002 3/03/19 3/28/19 784.87 0.00 784.87
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
Balance Valid-disc Cash-due
Customer totals: 889.36 0.00 889.36
Total: Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________
====================================================================================================================================
300 Beverly Beauty Supply BAL-FORWD 2/10 Net 30 3/30/19 Check #: _________ Ref: _________________________
750 N. Beverely Blvd.
Balance Valid-disc Cash-due
Customer totals: 1,860.40- 0.00
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
====================================================================================================================================
600 Ariel Enterprises BAL-FORWD Normal Terms 3/30/19 Check #: _________ Ref: _________________________
555 N. Grand Blvd.
Balance Valid-disc Cash-due
Customer totals: 561.75 0.00 561.75
Amt-to-pay ________________ Disc-to-take _____________ Allowance _____________ Allow-acct _________________
-- End of report --
Date 04/05/2019 Time 15:11:52 XYZ Company Report #0093 Page 0001
M I S C E L L A N E O U S C H A R G E S J O U R N A L
Sales entries are printed in document number order
Current period end date: 3/31/19
Document types: CR = credit memo, DR = debit memo, FIN = finance charge, INVC = invoice
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Doc-# Tx-Cd Apply-to Sale-amt Freight Total-amt P.O.-#
Doc-type Reference Doc-date Terms Due-date Misc-chgs Sales-Tax Cost Sls-rep Commission
------------------------------------------------------------------------------------------------------------------------------------
600 Ariel Enterprises 477 CTY 864.34 47.00 971.84
INVC 02/05/19 A 03/07/19 0.00 60.50 452.19 23 0.00
Automatic distributions: 2210-000 County sales taxes payable 60.50
Optional distributions: 4000-100 Sales - misc. items 864.34
4030-000 Freight - shipping 47.00
600 Ariel Enterprises 478 CTY 348.88 0.00 377.30
INVC 02/05/19 A 03/07/19 4.00 24.42 137.30 23 0.00
Automatic distributions: 2210-000 County sales taxes payable 24.42
Optional distributions: 4000-100 Sales - misc. items 348.88
4040-000 Misc. charges on sales 4.00
600 Ariel Enterprises 479 CTY 300.00 0.00 300.00
INVC 03/25/19 A 04/24/19 0.00 0.00 0.00 23 0.00
Optional distributions: 4000-100 Sales - misc. items 300.00
Date 04/05/2019 Time 15:11:52 XYZ Company Report #0093 Page 0002
M I S C E L L A N E O U S C H A R G E S J O U R N A L
Grand totals
------------------------------------------------------------------------------------------------------------------------------------
Sale-amt Freight Total-amt
Misc-chgs Sales-Tax Cost Commission
------------------------------------------------------------------------------------------------------------------------------------
3 entries Grand totals: 1,513.22 47.00 1,649.14
4.00 84.92 589.49 0.00
Acct-# Description Debits Credits
Distribution summary: 1100-000 Accounts receivable 1,649.14 .00
2210-000 County sales taxes payable .00 84.92
4000-100 Sales - misc. items .00 1,513.22
4030-000 Freight - shipping .00 47.00
4040-000 Misc. charges on sales .00 4.00
-------------------------------------------
Totals: 1,649.14 1,649.14
-- End of report --
Miscellaneous Cash Charges Journal
Date 04/05/2019 Time 15:54:13 XYZ Company Report #0097 Page 0001
M I S C E L L A N E O U S C H A R G E S J O U R N A L
Sales entries are printed in document number order
Current period end date: 3/31/19
Document types: CR = credit memo, DR = debit memo, FIN = finance charge, INVC = invoice
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Doc-# Tx-Cd Apply-to Sale-amt Freight Total-amt P.O.-#
Doc-type Reference Doc-date Terms Due-date Misc-chgs Sales-Tax Cost Sls-rep Commission
------------------------------------------------------------------------------------------------------------------------------------
200 21st Century Enterprises 599 CAL 800.00 0.00 840.00
INVC 02/05/19 3 03/02/19 0.00 40.00 488.00 10 20.00
Automatic distributions: 2200-000 State sales taxes payable 40.00
Job-# Sub Acct-# Amount Reference-1 Reference-2
99 2700-000 800.00
Date 04/05/2019 Time 15:54:13 XYZ Company Report #0097 Page 0002
M I S C E L L A N E O U S C H A R G E S J O U R N A L
Grand totals
------------------------------------------------------------------------------------------------------------------------------------
Sale-amt Freight Total-amt
Misc-chgs Sales-Tax Cost Commission
------------------------------------------------------------------------------------------------------------------------------------
1 entries Grand totals: 800.00 0.00 840.00
0.00 40.00 488.00 20.00
Total retainage: .00
Total CR to jobs: 800.00
Total DR to jobs: .00
Acct-# Description Debits Credits
Distribution summary: 1100-000 Accounts receivable 840.00 .00
2200-000 State sales taxes payable .00 40.00
2700-000 Billings on jobs .00 800.00
-------------------------------------------
Totals: 840.00 840.00
-- End of report --
Date 04/06/2019 Time 10:47:12 XYZ Company Report #0102 Page 0001
R E T U R N E D C H E C K S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
600 Ariel Enterprises BAL-FORWD 03/26/19 5566 150.00 1000-000
Ref/Bank Rte: 125-6992 Cash account #13557
Discount Allowance Total-debited Allowance-account
0.00 0.00 150.00
Bank charge: 25.00 Exp account: 7100-000
Bank charges
Cust charge: 30.00 Rev account: 4040-000
Misc. charges on sales
Date 04/06/2019 Time 10:47:12 XYZ Company Report #0102 Page 0002
R E T U R N E D C H E C K S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
Returned Check
1 Entries Grand totals:
--------------
Amount received: 150.00
Discounts allowed: 0.00
Allowances: 0.00
Total debited: 150.00
Total debited to A/R: 150.00
Total other debited: 0.00
Cash accounts: Debits Credits Checks
1000-000 Cash account #13557 0.00 150.00 150.00
--------------------- --------------------- ---------------------
Totals for cash accounts: 0.00 150.00 150.00
A/R accounts:
1100-000 Accounts receivable 150.00 0.00
--------------------- ---------------------
Totals for A/R accounts: 150.00 0.00
All other accounts:
--------------------- ---------------------
Totals for all other accounts: 0.00 0.00
Totals for all accounts: 150.00 150.00
Date 04/06/2019 Time 10:47:12 XYZ Company Report #0102 Page 0003
R E T U R N E D C H E C K S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
Charges
Grand totals:
--------------
Bank charges: 25.00
Cash accounts: Debits Credits Checks
1000-000 Cash account #13557 25.00
--------------------- --------------------- ---------------------
Totals for cash accounts: 0.00 25.00
Exp accounts:
7100-000 Bank charges 25.00
--------------------- --------------------- ---------------------
Totals for Exp accounts: 25.00 0.00
Customer charges: 30.00
Unposted Rev accounts:
4040-000 Misc. charges on sales 30.00
--------------------- --------------------- ---------------------
Totals for Rev accounts: 0.00 30.00
Unposted debit memos:
Totals for debit memos: 30.00 0.00
Customer charge debit memos will transfer to Miscellaneous Charges.
-- End of report --
Date 04/06/2019 Time 10:47:44 XYZ Company Report #0103 Page 0001
R E T U R N E D C H E C K S J O U R N A L
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
600 Ariel Enterprises BAL-FORWD 03/26/19 5566 150.00 1000-000
Ref/Bank Rte: 125-6992 Cash account #13557
Discount Allowance Total-debited Allowance-account
0.00 0.00 150.00
Bank charge: 25.00 Exp account: 7100-000
Bank charges
Cust charge: 30.00 Rev account: 4040-000
Misc. charges on sales
Date 04/06/2019 Time 10:47:44 XYZ Company Report #0103 Page 0002
R E T U R N E D C H E C K S J O U R N A L
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
Returned Check
1 Entries Grand totals:
--------------
Amount received: 150.00
Discounts allowed: 0.00
Allowances: 0.00
Total debited: 150.00
Total debited to A/R: 150.00
Total other debited: 0.00
Cash accounts: Debits Credits Checks
1000-000 Cash account #13557 0.00 150.00 150.00
--------------------- --------------------- ---------------------
Totals for cash accounts: 0.00 150.00 150.00
A/R accounts:
1100-000 Accounts receivable 150.00 0.00
--------------------- ---------------------
Totals for A/R accounts: 150.00 0.00
All other accounts:
--------------------- ---------------------
Totals for all other accounts: 0.00 0.00
Totals for all accounts: 150.00 150.00
Date 04/06/2019 Time 10:47:44 XYZ Company Report #0103 Page 0003
R E T U R N E D C H E C K S J O U R N A L
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
Charges
Grand totals:
--------------
Bank charges: 25.00
Cash accounts: Debits Credits Checks
1000-000 Cash account #13557 25.00
--------------------- --------------------- ---------------------
Totals for cash accounts: 0.00 25.00
Exp accounts:
7100-000 Bank charges 25.00
--------------------- --------------------- ---------------------
Totals for Exp accounts: 25.00 0.00
Customer charges: 30.00
Unposted Rev accounts:
4040-000 Misc. charges on sales 30.00
--------------------- --------------------- ---------------------
Totals for Rev accounts: 0.00 30.00
Unposted debit memos:
Totals for debit memos: 30.00 0.00
Customer charge debit memos will transfer to Miscellaneous Charges.
Please post Miscellaneous Charges to complete this process.
-- End of report --
Date 04/06/2019 Time 12:56:42 XYZ Company Report #0104 Page 0001
R E C U R R I N G B I L L S L I S T
Starting cust #: “First”
Ending cust #: “Last”
“Next date” cut-off: “Latest”
“*” after quantity indicates item is drop shipped.
Reference-#: 9874 Group: AAA Cust-#: 10 Harris, Goldberg & Jones Ship-to: * SAME AS BILL ADDRESS *
Sub acct: 100 456 W. 7th Street
Suite 100
San Diego, CA 92100
Country: USA
Cust-PO-#: Invc-disc-%: 0.000 Ship date:
Terms: Normal Terms Tax code: Taxable Sales Cal State F.O.B.:
Ship-via: Parcel Post Sales rep: William B. Wilkenson Contract #:
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- G/L account Commisnbl?
Unit Description-1 Price/unit Line-item-net
Description-2 Lin-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Goods 50 15MW 4000-100 Y
LNFT 15 mil insulated wire 0.08500/LNFT 4.14
(red insulation) 2.500% 0.02500 Y
1 line item
Invoice total: 4.14
Invoice disc: 0.00
Misc charges: 0.00
Freight: 0.00
Sales tax: 0.21 Taxable: 4.14
Total bill: 4.35 Commisnbl: 4.14 Commis amt: 0.00
Tax rate-1 0.21
Recurrence information: Interval: every 1 week Already billed: 0.00 Previous bill-ref#: NONE YET
Next date: 4/06/19 Max # of times: INDEFINITE Previous invoice #: NONE YET
Start date: 4/06/19 Times so far: 0 Previous invc date: NONE YET
Final date: INDEFINITE
Date 04/06/2019 Time 12:56:42 XYZ Company Report #0104 Page 0002
R E C U R R I N G B I L L S L I S T
Reference-#: 3371 Group: AAA Cust-#: 100 Neptune Underwater Supply Ship-to: * SAME AS BILL ADDRESS *
Sub acct: 100 345 Fisherman’s Pier
Santa Marina, CA 91100
Country: USA
Cust-PO-#: 55815 Invc-disc-%: 0.000 Ship date:
Terms: Net 30 Tax code: Taxable Sales L.A. County F.O.B.:
Ship-via: Air Freight Sales rep: Margaret Rockwell Contract #:
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- G/L account Commisnbl?
Unit Description-1 Price/unit Line-item-net
Description-2 Lin-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Svcs 1 Primary installation 4000-100
Svc#: 1 HOUR 50.00/HOUR 50.00
25.00
1 line item
Invoice total: 50.00
Invoice disc: 0.00
Misc charges: 0.00
Freight: 0.00
Sales tax: 0.00 Taxable: 0.00
Total bill: 50.00 Commisnbl: 0.00 Commis amt: 0.00
Recurrence information: Interval: every 1 month Already billed: 0.00 Previous bill-ref#: NONE YET
Next date: 4/15/19 Max # of times: INDEFINITE Previous invoice #: NONE YET
Start date: 3/15/19 Times so far: 0 Previous invc date: NONE YET
Final date: INDEFINITE
-- End of report --
Date 04/05/2019 Time 16:09:02 XYZ Company Report #0100 Page 0002
C A S H R E C E I P T S J O U R N A L
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-meth Rect-dat Check-# Amount-recd Cash-account
------------------------------------------------------------------------------------------------------------------------------------
1 Entries Grand totals:
-------------
Amount received: 250.00
Discounts allowed: 0.00
Allowances: 0.00
Total credited: 250.00
Total credited to A/R: 250.00
Total other credited: 0.00
Cash accounts: Debits Credits Checks Cash
1000-000 Cash account #13557 250.00 0.00 250.00 0.00
------------------ ------------------ ------------------ ------------------
Totals for cash accounts: 250.00 0.00 250.00 0.00
A/R accounts:
1100-000 Accounts receivable 0.00 250.00
--------------------- ---------------------
Totals for A/R accounts: 0.00 250.00
All other accounts:
--------------------- ---------------------
Totals for all other accounts: 0.00 0.00
Totals for all accounts: 250.00 250.00
-- End of report --
Recurring Bills Automatic Selection List
Date 04/06/2019 Time 13:03:52 XYZ Company Report #0105 Page 0001
R E C U R R I N G B I L L S A U T O M A T I C S E L E C T I O N L I S T
Starting cust #: “First”
Ending cust #: “Last”
“Next date” cut-off: “Latest”
“*” after quantity indicates item is drop shipped.
Reference-#: 9874 Group: AAA Cust-#: 10 Harris, Goldberg & Jones Ship-to: * SAME AS BILL ADDRESS *
Sub acct: 100 456 W. 7th Street
Suite 100
San Diego, CA 92100
Country: USA
Cust-PO-#: Invc-disc-%: 0.000 Ship date:
Terms: Normal Terms Tax code: Taxable Sales Cal State F.O.B.:
Ship-via: Parcel Post Sales rep: William B. Wilkenson Contract #:
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- G/L account Contract # Commisnbl?
Unit Description-1 Price/unit Line-item-net
Description-2 Lin-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Goods 50 15MW 4000-100 Y
LNFT 15 mil insulated wire 0.08500/LNFT 4.14
(red insulation) 2.500% 0.02500 Y
1 line item
Invoice total: 4.14
Invoice disc: 0.00
Misc charges: 0.00
Freight: 0.00
Sales tax: 0.21 Taxable: 4.14
Total bill: 4.35 Commisnbl: 4.14 Commis amt: 0.00
Tax rate-1 0.21
Recurrence information: Interval: every 1 week Already billed: 0.00 Previous bill-ref#: NONE YET
Next date: 4/06/19 Max # of times: INDEFINITE Previous invoice #: NONE YET
Start date: 4/06/19 Times so far: 0 Previous invc date:
Final date: INDEFINITE
Date 04/06/2019 Time 13:03:52 XYZ Company Report #0105 Page 0002
R E C U R R I N G B I L L S A U T O M A T I C S E L E C T I O N L I S T
Reference-#: 3371 Group: AAA Cust-#: 100 Neptune Underwater Supply Ship-to: * SAME AS BILL ADDRESS *
Sub acct: 100 345 Fisherman’s Pier
Santa Marina, CA 91100
Country: USA
Cust-PO-#: 55815 Invc-disc-%: 0.000 Ship date:
Terms: Net 30 Tax code: Taxable Sales L.A. County F.O.B.:
Ship-via: Air Freight Sales rep: Margaret Rockwell Contract #:
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- G/L account Contract # Commisnbl?
Unit Description-1 Price/unit Line-item-net
Description-2 Lin-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Svcs 1 Primary installation 4000-100
Svc#: 1 HOUR 50.00/HOUR 50.00
25.00
1 line item
Invoice total: 50.00
Invoice disc: 0.00
Misc charges: 0.00
Freight: 0.00
Sales tax: 0.00 Taxable: 0.00
Total bill: 50.00 Commisnbl: 0.00 Commis amt: 0.00
Recurrence information: Interval: every 1 month Already billed: 0.00 Previous bill-ref#: NONE YET
Next date: 4/15/19 Max # of times: INDEFINITE Previous invoice #: NONE YET
Start date: 3/15/19 Times so far: 0 Previous invc date:
Final date: INDEFINITE
-- End of report --
Date 04/06/2019 Time 14:51:53 XYZ Company Report #0107 Page 0001
S T A N D A R D B I L L S L I S T
“*” after quantity indicates item is drop shipped.
Standard bill: 1 Standard bill #1 (contains 2 line items)
Survey & est.; 1 yr servc
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- Sls-account A/R-ship-instr Commis
Unit Description-1 Price/unit Line-item-net
Description-2 Ln-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Svcs 4 Survey and estimate 4000-000 No
Svc#: 3 HOUR 35.00/HOUR 140.00
0.000 19.00 N/N/N/N/N
20 Svcs 1 1 year service and maintenance 4000-000 No
Svc#: 2 400.00
0.000 150.00000 N/N/N/N/N
Line item total: 540.00
Date 04/06/2019 Time 14:51:53 XYZ Company Report #0107 Page 0002
S T A N D A R D B I L L S L I S T
Standard bill: 2 Standard bill #2 (contains 2 line items)
4’ A/C hose; 3hr Install.
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- Sls-account A/R-ship-instr Commis
Unit Description-1 Price/unit Line-item-net
Description-2 Ln-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Goods 4 2 4000-000 Ship in stock No
FT. Air conditioning hose 3.55/FT. 14.20
0.000 1.75 Y/Y/Y/Y/Y
20 Svcs 3 Primary installation 4000-000 Yes
Svc#: 1 HOUR 50.00/HOUR 150.00
0.000 25.00 Y/Y/Y/Y/Y
30 Notes Please note the shipping/service date on the
invoice. Charges will be accepted by us up to
24 hours prior to shipping.
Line item total: 164.20
Date 04/06/2019 Time 14:51:53 XYZ Company Report #0107 Page 0003
S T A N D A R D B I L L S L I S T
Standard bill: 3 Standard Bill #3 (contains 2 line items)
Extended Service Agreemnt
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- Sls-account A/R-ship-instr Commis
Unit Description-1 Price/unit Line-item-net
Description-2 Ln-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Svcs 1 1 year service and maintenance 4000-000 Yes
Svc#: 2 340.00
15.000% 150.00000 N/N/N/N/N
20 Svcs 12 Monthly check & services 4000-000 Yes
Svc#: 4 HOUR 10.00/HOUR 102.00
15.000% 6.50 Y/Y/Y/Y/Y
Line item total: 442.00
Date 04/06/2019 Time 14:51:53 XYZ Company Report #0107 Page 0004
S T A N D A R D B I L L S L I S T
Standard bill: 4 Standard bill #4 (contains 2 line items)
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Quantity ----------------Item/Service/Note----------------- Sls-account A/R-ship-instr Commis
Unit Description-1 Price/unit Line-item-net
Description-2 Ln-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Svcs 1 Primary installation 4000- Yes
Svc#: 1 HOUR 50.00/HOUR 50.00
0.000 25.00 Y/Y/Y/Y/Y
20 Notes Standard maintenance checks
per checklist
Line item total: 50.00
-- End of report --
Date 04/06/2019 Time 15:23:32 XYZ Company Report #0108 Page 0001
M I S C E L L A N E O U S C H A R G E S E D I T L I S T
Sales entries are printed in document number order
Current period end date: 3/31/19
Document types: CR = credit memo, DR = debit memo, FIN = finance charge, INVC = invoice
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Doc-# Tx-Cd Apply-to Sale-amt Freight Total-amt P.O.-#
Doc-type Reference Doc-date Terms Due-date Misc-chgs Sales-Tax Cost Sls-rep Commission
------------------------------------------------------------------------------------------------------------------------------------
200 21st Century Enterprises 2002 CAL 300.00 0.00 340.00 146
INVC Special Order 03/01/19 3 03/26/19 25.00 15.00 172.50 10 7.50
Automatic distributions: 4040-000 Misc. charges on sales 25.00
2200-000 State sales taxes payable 15.00
Optional distributions: 4000-100 Sales - misc. items 300.00
600 Ariel Enterprises 5566 CTY 5566 30.00 0.00 30.00
DR Returned check 03/26/19 A 03/26/19 0.00 0.00 0.00 23 0.00
Optional distributions: 4040-000 Misc. charges on sales 30.00
Date 04/06/2019 Time 15:23:32 XYZ Company Report #0108 Page 0002
M I S C E L L A N E O U S C H A R G E S E D I T L I S T
Grand totals
------------------------------------------------------------------------------------------------------------------------------------
Sale-amt Freight Total-amt
Misc-chgs Sales-Tax Cost Commission
------------------------------------------------------------------------------------------------------------------------------------
2 entries Grand totals: 330.00 0.00 370.00
25.00 15.00 172.50 7.50
Acct-# Description Debits Credits
Distribution summary: 1100-000 Accounts receivable 370.00 .00
2200-000 State sales taxes payable .00 15.00
4000-100 Sales - misc. items .00 300.00
4040-000 Misc. charges on sales .00 55.00
-------------------------------------------
Totals: 370.00 370.00
-- End of report --
Date 04/06/2019 Time 15:33:48 XYZ Company Report #0110 Page 0001
P A S T D U E C U S T O M E R U P D A T E L I S T
“*” next to customer name means a new past due customer
------------------------------------------------------------------------------------------------------------------------------------
Customer # Customer Name Contact Name Telephone # Balance
------------------------------------------------------------------------------------------------------------------------------------
1 *Elliot Enterprises Paul Elliot 213-779-6010 312.44
10 *Harris, Goldberg & Jones Michael Jones 714-221-8500 290.22
40 *Washington, Mrs. Thomas Ann Washington 617-444-7780 955.00
50 *Space Concepts & Design Mike Mallin 212-220-9981 235.00
99 *Anthony Jones, Inc. T.A. Wagner 123-456-7890 583.80
200 *21st Century Enterprises Lou Mandel 415-555-7844 1,229.36
600 *Ariel Enterprises M.J. Thorpe 213-554-4300 1,940.89
------------------------------------------------------------------------------------------------------------------------------------
-- End of report --
Date 04/06/2019 Time 16:40:02 XYZ Company Report #0111 Page 0001
F I N A N C E C H A R G E S E D I T L I S T
For open items thru 03/31/19
------------------------------------------------------------------------------------------------------------------------------------
------------Customer------------------- Past due Finance
# Name amount charge
------------------------------------------------------------------------------------------------------------------------------------
1 Elliot Enterprises 312.44 4.69
10 Harris, Goldberg & Jones 290.22 4.35
40 Washington, Mrs. Thomas 955.00 14.33
50 Space Concepts & Design 235.00 3.53
99 Anthony Jones, Inc. 583.80 8.76
200 21st Century Enterprises 104.49 1.57
600 Ariel Enterprises 411.75 6.18
Totals: 2,892.70 43.41
-- End of report --
------------------------------------------------------------------------------------------------------------------------------------
Date 06/21/2013 Time 14:39:35 XYZ Company Report #0000024 Page 0001
C H E C K B O O K T R A N S F E R R E G I S T E R
Transferred from Accounts Receivable
Depos-# Depos-date Amount
------------------------------------------------------------------------------------------------------------------------------------
Checking account: 1001-000 Cash account
207 6/22/13 120.00
Date Check-# Amount Customer-# Name Reference
6/21/13 *CASH* 20.00 300 Beverly Beauty Supply Beverly Beauty Supply
6/21/13 00008746 100.00 300 Beverly Beauty Supply Beverly Beauty Supply
Account total: 120.00
------------------------------------------------------------------------------------------------------------------------------------
Date 06/21/2013 Time 14:39:35 XYZ Company Report #0000024 Page 0002
C H E C K B O O K T R A N S F E R R E G I S T E R
Depos-# Depos-date Amount
------------------------------------------------------------------------------------------------------------------------------------
Total transferred: 120.00
-- End of report --
Date 04/06/2019 Time 16:58:55 XYZ Company Report #0112 Page 0001
D E P O S I T S U M M A R Y
Cash account: 1000-000 Cash account #13557
For deposit numbers: “First” thru “Last”
------------------------------------------------------------------------------------------------------------------------------------
Deposit-# Date Amount Status
------------------------------------------------------------------------------------------------------------------------------------
1 4/12/19 9,390.00 Transferred to checkbook
199903 3/26/19 150.00- Printed
199903 3/26/19 25.00- Not yet printed
-- End of report --
Accounts Receivable Detail Aging Report
Date 04/06/2019 Time 17:09:13 XYZ Company Report #0113 Page 0001
A C C O U N T S R E C E I V A B L E D E T A I L A G I N G R E P O R T
Selections for this report: Aging periods:
1. Aging date 3/31/19 Age by invoice date 1. Define aging periods by Days
2. By cust number or name ? Number
3. Starting customer 200 2. # aging days in prd 1 30
4. Ending customer 300 3. Period 1 description Current
5. Group by A/R account ? Y
6. For which A/R account ? “All”
4. # aging days in prd 2 60
5. Period 2 description Over 30 days
7. Print DR/CR bal customers ? Both
8. Show zero bal customers ? Y
6. # aging days in prd 3 90
9. Detail or summary ? Detail 7. Period 3 description Over 60 days
10. Age open item customers
like bal forward customers ? N
8. # aging days in prd 4 999
11. Show invoice balances only ? N 9. Period 4 description Over 90 days
12. Print P.O.# or reference ? Reference
Date 04/06/2019 Time 17:09:13 XYZ Company Report #0113 Page 0002
A C C O U N T S R E C E I V A B L E D E T A I L A G I N G R E P O R T
Aging date: 3/31/19
Document types: I = Invoice P = Payment C = Cr memo D = Dr memo B = Balance forward F = Finance charge R = Returned check
Notes: On types I, B, C, D and R, Amount-1 is the amount subject to discount. On type P Amount-1 is cash receipt amt.
On type F Amount-1 is fin charge amt. On types I, C, D and R, Amount-2 is the amount not subject to discount.
On type P Amount-2 is discount plus allowance. (No Amount-2 for types F & B).
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance ---------------------Aged customer balances-----------------
Contact-1 Address-1 Credit-limit Current Over 30 days Over 60 days Over 90 days
Phone-#-1 Address-2 Terms
Phone-#-2 City/State/Zip Last-pmt-dat
------------------------------------------------------------------------------------------------------------------------------------
A/R account: 1100-000 Accounts receivable
=============================================================
200 OPN-ITM 21st Century Enterprises 1,229.36 1,124.87 0.00 104.49 0.00
Lou Mandel P.O. Box 4545 20,000.00
415-555-7844 670 Mason Street 5/10 net 25 92% 0% 8% 0%
415-555-7845 San Francisco, CA 95782 3/12/19
Country: USA
Doc-# Doc-date Typ Apply-to Due-date Reference Amount-1 Amount-2 Doc-total Age
1025 1/25/19 I 1025 2/19/19 From O/E order: 000039 575.70 28.79 604.49 65
349 3/12/19 P 1025 3/12/19 500.00- 0.00 500.00- 19
2002 3/01/19 I 2002 3/26/19 Special Order 300.00 40.00 340.00 30
3002 3/03/19 I 3002 3/28/19 Regular purchase 715.45 69.42 784.87 28
====================================================================================================================================
300 BAL-FWD Beverly Beauty Supply 1,860.40- 1,860.40- 0.00 0.00 0.00
Angie Peters 750 N. Beverely Blvd. 50,000.00
213-778-9000 2/10 Net 30 0% 0% 0% 0%
Los Angeles, CA 90005 3/12/19
Country: USA
Doc-# Doc-date Typ Apply-to Due-date Reference Amount-1 Amount-2 Doc-total Age
1026 1/25/19 I 2/24/19 From O/E order: 000040 132.95 9.31 142.26 65
1/29/19 P 1/29/19 250.00- 2.66- 252.66- 61
349 3/12/19 P 3/12/19 125-6992 1,500.00- 250.00- 1,750.00- 19
====================================================================================================================================
Date 04/06/2019 Time 17:09:13 XYZ Company Report #0113 Page 0003
A C C O U N T S R E C E I V A B L E D E T A I L A G I N G R E P O R T
Aging date: 3/31/19
Document types: I = Invoice P = Payment C = Cr memo D = Dr memo B = Balance forward F = Finance charge R = Returned check
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance ---------------------Aged customer balances-----------------
Contact-1 Address-1 Credit-limit Current Over 30 days Over 60 days Over 90 days
Phone-#-1 Address-2 Terms
Phone-#-2 City/State/Zip Last-pmt-dat
------------------------------------------------------------------------------------------------------------------------------------
Totals for: 1100-000 Accounts receivable
DR lines show totals for customers with debit balances as of the aging date
CR lines show totals for customers with credit balances as of the aging date
Total Current Over 30 days Over 60 days Over 90 days
--------------------------------------------------------------------------------------------------------------
DR bal cust totals: 1,229.36 1,124.87 92% 0.00 0% 104.49 8% 0.00 0%
CR bal cust totals: 1,860.40- 1,860.40-100% 0.00 0% 0.00 0% 0.00 0%
--------------------------------------------------------------------------------------------------------------
Net totals: 631.04- 735.53- 0% 0.00 0% 104.49 100% 0.00 0%
==============================================================================================================
-- End of report --
Date 04/07/2019 Time 11:00:16 XYZ Company Report #0114 Page 0001
C O L L E C T I O N S D E T A I L R E P O R T
Selections for this report: Aging periods:
1. Cut-off date 4/30/19 Age by due date 1. Define aging periods by Days
2. By cust number or name ? Number
3. Starting customer 200 2. # aging days in prd 1 30
4. Ending customer 300 3. Period 1 description Current
5. Last payment cut-off date ? No cut-off
6. Group by sales rep ? Not applicable
7. For which sales rep ? Not applicable 4. # aging days in prd 2 60
5. Period 2 description Over 30 days
8. Cut-off balance due “All”
9. Cut-off aging period “All”
10. Print DR/CR bal customers ? Both 6. # aging days in prd 3 90
11. Show zero bal customers ? N 7. Period 3 description Over 60 days
12. Detail or summary ? Detail
13. Age open item customers 8. # aging days in prd 4 999
like bal forward customers ? N 9. Period 4 description Over 90 days
14. Show invoice balances only ? N
15. Print P.O.# or reference ? Reference
Date 04/07/2019 Time 11:00:16 XYZ Company Report #0114 Page 0002
C O L L E C T I O N S D E T A I L R E P O R T
Cut-off date: 4/30/19
Document types: I = Invoice P = Payment C = Cr memo D = Dr memo B = Balance forward F = Finance charge R = Returned check
Notes: On types I, B, C, D and R, Amount-1 is the amount subject to discount. On type P Amount-1 is cash receipt amt.
On type F Amount-1 is fin charge amt. On types I, C, D and R, Amount-2 is the amount not subject to discount.
On type P Amount-2 is discount plus allowance. (No Amount-2 for types F & B).
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance ---------------------Aged customer balances-----------------
Contact-1 Sales-rep Credit-limit Current Over 30 days Over 60 days Over 90 days
Phone-#-1 A/R-account-# Terms
Phone-#-2 1st-sls-dat Last-sls-dat Last-pmt-dat Last-pmt-amt
------------------------------------------------------------------------------------------------------------------------------------
200 OPN-ITM 21st Century Enterprises 1,229.36 0.00 1,124.87 104.49 0.00
Lou Mandel William B. Wilkenson 20,000.00 92% 8%
415-555-7844 1100-000 5/10 net 25
415-555-7845 Accounts receivable 1/25/19 3/01/19 3/12/19 500.00
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------- -------- ---------------- ---------------- ----------------
YTD 46.00 604.49 944.49 500.00 Last sale amt: 300.00
QTR1 46.00 604.49 944.49 500.00
Past due amt: 1,229.36
Past due calc dat 04/06/19
Credit Hold:
Doc-# Doc-date Typ Apply-to Due-date Reference Amount-1 Amount-2 Doc-total Age
1025 1/25/19 I 1025 2/19/19 From O/E order: 000039 575.70 28.79 604.49 70
349 3/12/19 P 1025 3/12/19 500.00- 0.00 500.00- 49
2002 3/01/19 I 2002 3/26/19 Special Order 300.00 40.00 340.00 35
3002 3/03/19 I 3002 3/28/19 Regular purchase 715.45 69.42 784.87 33
====================================================================================================================================
300 BAL-FWD Beverly Beauty Supply 1,860.40- 1,860.40- 0.00 0.00 0.00
Angie Peters Margaret Rockwell 50,000.00
213-778-9000 1100-000 2/10 Net 30
Accounts receivable 1/25/19 1/25/19 3/12/19 1,500.00
Avg-days Total-payments
Period to-pay Highest-Bal Total-charges received
------- -------- ---------------- ---------------- ----------------
YTD 0.00 142.26 142.26 1,750.00 Last sale amt: 132.95
QTR1 0.00 142.26 142.26 1,750.00
Past due amt: 0.00
Past due calc dat None
Credit Hold:
Doc-# Doc-date Typ Apply-to Due-date Reference Amount-1 Amount-2 Doc-total Age
1026 1/25/19 I 2/24/19 From O/E order: 000040 132.95 9.31 142.26 65
1/29/19 P 1/29/19 250.00- 2.66- 252.66- 91
349 3/12/19 P 3/12/19 125-6992 1,500.00- 250.00- 1,750.00- 49
====================================================================================================================================
Date 04/07/2019 Time 11:00:16 XYZ Company Report #0114 Page 0003
C O L L E C T I O N S D E T A I L R E P O R T
Cut-off date: 4/30/19
Document types: I = Invoice P = Payment C = Cr memo D = Dr memo B = Balance forward F = Finance charge R = Returned check
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Balance ---------------------Aged customer balances-----------------
Contact-1 Sales-rep Credit-limit Current Over 30 days Over 60 days Over 90 days
Phone-#-1 A/R-account-# Terms
Phone-#-2 1st-sls-dat Last-sls-dat Last-pmt-dat Last-pmt-amt
------------------------------------------------------------------------------------------------------------------------------------
Grand totals for 2 customers printed
DR lines show totals for customers with debit balances as of the cut-off date
CR lines show totals for customers with credit balances as of the cut-off date
Total Current Over 30 days Over 60 days Over 90 days
--------------------------------------------------------------------------------------------------------------
DR bal cust totals: 1,229.36 0.00 1,124.87 92% 104.49 8% 0.00
CR bal cust totals: 1,860.40- 1,860.40-100% 0.00 0.00 0.00
--------------------------------------------------------------------------------------------------------------
Net totals: 631.04- 1,860.40- 1,124.87 92% 104.49 8% 0.00
==============================================================================================================
-- End of report --
Date 04/07/2019 Time 11:09:06 XYZ Company Report #0115 Page 0001
C A S H P R O J E C T I O N D E T A I L R E P O R T
Customer # range: “First” Thru “Last”
Sales rep: 010 William B. Wilkenson
Document types: I = Invoice, P = Payment, C = Cr memo, D = Dr memo, B = Balance forward, F = Finance charge
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-method Contact-1 Phone-1 Cred-rte Cred-limit
------------------------------------------------------------------------------------------------------------------------------------
10 Harris, Goldberg & Jones Open item Michael Jones 714-221-8500 *Unltd cr*
Doc-# Doc-date Typ Apply-to Due-date Up-to- 3/31/19 Thru- 4/30/19 Thru- 5/31/19 Thru- 6/30/19 After- 6/30/19
1019 1/25/19 I 1019 2/24/19 290.22 0.00 0.00 0.00 0.00
Customer 10 totals 290.22 0.00 0.00 0.00 0.00
200 21st Century Enterprises Open item Lou Mandel 415-555-7844 AA 20,000
Doc-# Doc-date Typ Apply-to Due-date Up-to- 3/31/19 Thru- 4/30/19 Thru- 5/31/19 Thru- 6/30/19 After- 6/30/19
1025 1/25/19 I 1025 2/19/19 604.49 0.00 0.00 0.00 0.00
349 3/12/19 P 1025 3/12/19 500.00- 0.00 0.00 0.00 0.00
2002 3/01/19 I 2002 3/26/19 340.00 0.00 0.00 0.00 0.00
3002 3/03/19 I 3002 3/28/19 784.87 0.00 0.00 0.00 0.00
Customer 200 totals 1,229.36 0.00 0.00 0.00 0.00
Grand totals 1,519.58 0.00 0.00 0.00 0.00
-- End of report --
This example of the report is for commissions paid on sales.
Date 04/07/2013 Time 11:40:47 XYZ Company Report #0119 Page 0001
C O M M I S S I O N S D U E R E P O R T
For documents dated from: 3/01/13 thru “Latest”
For sales reps: “First” thru “Last”
Document types: I = invoice B = bal fwd C = cr memo D = dr memo
Commission on receivables
------------------------------------------------------------------------------------------------------------------------------------
----------Sales rep----------- ---------------Customer--------------- ------Document------- Comm-amt Sale
# Name # Name # Type Date due amount
------------------------------------------------------------------------------------------------------------------------------------
10 William B. Wilkenson 200 21st Century Enterprises 2002 I 3/01/13 7.50 300.00
Customer 200 totals: 7.50 300.00
Sales rep 10 totals: 7.50 300.00
Grand totals: 7.50 300.00
-- End of report --
This example is of the report is for commissions paid on fully paid open items.
Date 03/07/2013 Time 13:14:35 XYZ Company Report-#0120 Page 0001
C O M M I S S I O N S D U E R E P O R T
For documents fully paid from: 3/01/13 thru "Latest"
For sales reps: "First" thru "Last"
Document types: I = invoice B = bal fwd C = cr memo D = dr memo
Commissions based on fully paid open items - Total amount includes sale amount, freight, miscellaneous charges, and sales tax
------------------------------------------------------------------------------------------------------------------------------------
# Sales-rep
------------------------------------------------------------------------------------------------------------------------------------
789 Avram Goldberger
Cust-# Customer-name Pmt-date Doc-# Type Date Apply-to Comm-amt-due Total-amount
800 Brazil Coffee 3/07/13 1422 I 9/27/12 1422 1.25 25.00
3/07/13 1435 I 11/02/12 1435 16.00 160.00
Customer 800 totals: 17.25 185.00
Sales rep 789 totals: 17.25 185.00
Grand totals: 17.25 185.00
-- End of report --
Date 04/07/2019 Time 11:46:29 XYZ Company Report #0120 Page 0001
S A L E S T A X D U E E D I T L I S T
Cut-off date: 04/07/19 Tax code: CTY Taxable Sales L.A. City Format: Detail
------------------------------------------------------------------------------------------------------------------------------------
Acct # Description
Doc-no Cust-no Doc-dat Tx-cd Ovrd Doc-typ Total amt Taxable amt Tax amt Uncol Tax amt
------------------------------------------------------------------------------------------------------------------------------------
2210-000 County sales taxes payable
477 600 2/05/19 CTY No INVOICE 971.84 864.34 60.50 0.00
478 600 2/05/19 CTY No INVOICE 377.30 348.88 24.42 0.00
1018 1 1/25/19 CTY No INVOICE 312.44 292.00 20.44 0.00
1020 30 1/25/19 CTY No INVOICE 174.41 163.00 11.41 0.00
1026 300 1/25/19 CTY No INVOICE 142.26 132.95 139.58 0.00
1027 600 1/25/19 CTY No INVOICE 561.75 525.00 36.75 0.00
Acct-Totals 2,540.00 2,326.17 293.10 0.00
Tax Totals 293.10 0.00
-- End of report --
Date 04/07/2019 Time 11:49:15 XYZ Company Report #0121 Page 0001
S A L E S T A X E X C E P T I O N R E P O R T
Starting date: 03/01/19 Ending date: 04/30/19
------------------------------------------------------------------------------------------------------------------------------------
Tax code Description
Doc no Cust-no Doc-typ Doc date Total sales amount Total taxable amount Total Sales tax
------------------------------------------------------------------------------------------------------------------------------------
CAL Taxable Sales Cal State
2002 200 INVOICE 3/01/19 340.00 300.00 15.00
------------------ ------------------ --------------
Tax code total 340.00 300.00 15.00
CTY Taxable Sales L.A. City
479 600 INVOICE 3/25/19 300.00 300.00 0.00
------------------ ------------------ --------------
Tax code total 300.00 300.00 .00
------------------ ------------------ --------------
Grand Total 640.00 600.00 15.00
-- End of report --
Accounts Receivable Distributions To General Ledger Report
Date 04/07/2019 Time 11:53:33 XYZ Company Report #0122 Page 0001
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
Income section
2200-000 State sales taxes payable
01/25/19 AR0025 13.82CR 10 Harris, Goldberg & Jones 1019
AR0025 27.80CR 99 Anthony Jones, Inc. 1023
AR0025 28.79CR 200 21st Century Enterprises 1025
Date total: 70.41CR
03/01/19 MC0109 15.00CR 200 21st Century Enterprises 2002
Date total: 15.00CR
Account total: 85.41CR
2210-000 County sales taxes payable
01/25/19 AR0025 20.44CR 1 Elliot Enterprises 1018
AR0025 11.41CR 30 W.J. Bjornfreg A/G 1020
AR0025 28.01CR 100 Neptune Underwater Supply 1024
AR0025 9.31CR 300 Beverly Beauty Supply 1026
AR0025 36.75CR 600 Ariel Enterprises 1027
Date total: 105.92CR
02/05/19 MC0093 60.50CR 600 Ariel Enterprises 477
MC0093 24.42CR 600 Ariel Enterprises 478
Date total: 84.92CR
Account total: 190.84CR
4000-100 Sales - misc. items
02/05/19 MC0093 864.34CR 600 Ariel Enterprises 477
MC0093 348.88CR 600 Ariel Enterprises 478
Date total: 1,213.22CR
Date 04/07/2019 Time 11:53:33 XYZ Company Report #0122 Page 0002
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
4000-100 Sales - misc. items (Continued)
03/01/19 MC0109 300.00CR 200 21st Century Enterprises 2002
Date total: 300.00CR
03/25/19 MC0093 300.00CR 600 Ariel Enterprises 479
Date total: 300.00CR
Account total: 1,813.22CR
4010-000 Equipment income/expense
01/25/19 AR0025 22.50CR 10 Harris, Goldberg & Jones 1019
AR0025 110.00CR 30 W.J. Bjornfreg A/G 1020
AR0025 675.00CR 40 Washington, Mrs. Thomas 1021
AR0025 560.25CR 100 Neptune Underwater Supply 1024
AR0025 45.00CR 300 Beverly Beauty Supply 1026
Date total: 1,412.75CR
Account total: 1,412.75CR
4010-100 Sales - tools
01/25/19 AR0025 292.00CR 1 Elliot Enterprises 1018
AR0025 253.90CR 10 Harris, Goldberg & Jones 1019
AR0025 53.00CR 30 W.J. Bjornfreg A/G 1020
AR0025 280.00CR 40 Washington, Mrs. Thomas 1021
AR0025 235.00CR 50 Space Concepts & Design 1022
AR0025 556.00CR 99 Anthony Jones, Inc. 1023
AR0025 575.70CR 200 21st Century Enterprises 1025
AR0025 87.95CR 300 Beverly Beauty Supply 1026
AR0025 525.00CR 600 Ariel Enterprises 1027
Date total: 2,858.55CR
Account total: 2,858.55CR
Date 04/07/2019 Time 11:53:33 XYZ Company Report #0122 Page 0003
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
4030-000 Freight - shipping
02/05/19 MC0093 47.00CR 600 Ariel Enterprises 477
Date total: 47.00CR
Account total: 47.00CR
4040-000 Misc. charges on sales
02/05/19 MC0093 4.00CR 600 Ariel Enterprises 478
Date total: 4.00CR
03/01/19 MC0109 25.00CR
Date total: 25.00CR
03/26/19 MC0109 30.00CR 600 Ariel Enterprises 5566
Date total: 30.00CR
Account total: 59.00CR
7100-000 Bank charges
03/26/19 CJ0103 25.00 600 Ariel Enterprises 5566
Date total: 25.00
Account total: 25.00
Section total: 6,441.77CR
Date 04/07/2019 Time 11:53:33 XYZ Company Report #0122 Page 0004
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
Cash receipts section
1000-000 Cash account #13557
01/29/19 CJ0034 500.00 100 Neptune Underwater Supply 1001
CJ0034 250.00 300 Beverly Beauty Supply
Date total: 750.00
01/30/19 CJ0034 5,000.00 30 W.J. Bjornfreg A/G 1359
Date total: 5,000.00
03/10/19 CJ0091 140.00 100 Neptune Underwater Supply 201
Date total: 140.00
03/12/19 CJ0091 1,500.00 200 21st Century Enterprises 348
CJ0091 500.00 200 21st Century Enterprises 349
CJ0091 1,500.00 300 Beverly Beauty Supply 349
Date total: 3,500.00
03/26/19 CJ0094 150.00 600 Ariel Enterprises 5566
CJ0103 150.00CR 600 Ariel Enterprises 5566
CJ0103 25.00CR 600 Ariel Enterprises 5566
Date total: 25.00CR
Account total: 9,365.00
4040-000 Misc. charges on sales
03/12/19 CJ0091 1,500.00CR 200 21st Century Enterprises 348
Date total: 1,500.00CR
Account total: 1,500.00CR
4050-300 Discounts allowed
Date 04/07/2019 Time 11:53:34 XYZ Company Report #0122 Page 0005
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
4050-300 Discounts allowed (Continued)
01/29/19 CJ0034 2.66 300 Beverly Beauty Supply
Date total: 2.66
Account total: 2.66
4060-000 Sales allowances
03/12/19 CJ0091 250.00 300 Beverly Beauty Supply 349
Date total: 250.00
Account total: 250.00
Section total: 8,117.66
Date 04/07/2019 Time 11:53:34 XYZ Company Report #0122 Page 0006
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
Net change to accounts receivable
1100-000 Accounts receivable
01/25/19 AR0025 312.44 1 Elliot Enterprises 1018
AR0025 290.22 10 Harris, Goldberg & Jones 1019
AR0025 174.41 30 W.J. Bjornfreg A/G 1020
AR0025 955.00 40 Washington, Mrs. Thomas 1021
AR0025 235.00 50 Space Concepts & Design 1022
AR0025 583.80 99 Anthony Jones, Inc. 1023
AR0025 588.26 100 Neptune Underwater Supply 1024
AR0025 604.49 200 21st Century Enterprises 1025
AR0025 142.26 300 Beverly Beauty Supply 1026
AR0025 561.75 600 Ariel Enterprises 1027
Date total: 4,447.63
01/29/19 CJ0034 500.00CR 100 Neptune Underwater Supply 1024
CJ0034 252.66CR 300 Beverly Beauty Supply
Date total: 752.66CR
01/30/19 CJ0034 5,000.00CR 30 W.J. Bjornfreg A/G
Date total: 5,000.00CR
02/05/19 MC0093 971.84 600 Ariel Enterprises 477
MC0093 377.30 600 Ariel Enterprises 478
Date total: 1,349.14
03/01/19 MC0109 340.00 200 21st Century Enterprises 2002
Date total: 340.00
03/10/19 CJ0091 140.00CR 100 Neptune Underwater Supply
Date total: 140.00CR
03/12/19 CJ0091 500.00CR 200 21st Century Enterprises 1025
CJ0091 1,750.00CR 300 Beverly Beauty Supply
Date total: 2,250.00CR
Date 04/07/2019 Time 11:53:34 XYZ Company Report #0122 Page 0007
A C C O U N T S R E C E I V A B L E D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: “Earliest” Ending date: 04/30/19
Journal codes: AR = Sales journal CJ = Cash journal & returned checks journal FJ = Finance charge journal MC = Misc. charges journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Cust-# Name Doc-#
------------------------------------------------------------------------------------------------------------------------------------
1100-000 Accounts receivable (Continued)
03/25/19 MC0093 300.00 600 Ariel Enterprises 479
Date total: 300.00
03/26/19 CJ0094 150.00CR 600 Ariel Enterprises
CJ0103 150.00 600 Ariel Enterprises
MC0109 30.00 600 Ariel Enterprises 5566
Date total: 30.00
Account total: 1,675.89CR
Section total: 1,675.89CR
Report total: .00
-- End of report --
Date 04/07/2019 Time 11:57:27 XYZ Company Report #0123 Page 0001
C A S H H I S T O R Y R E P O R T
Cash account: 1000-000 Cash account #13557
For receipts dated from: “Earliest” thru “Latest”
For customers: “First” thru “Last”
For deposit number: “All”
------------------------------------------------------------------------------------------------------------------------------------
Receipt ------------Customer------------------- Check Amount Credit Reference/Bank route # Journal Deposit
date number name number received A/R? number number
------------------------------------------------------------------------------------------------------------------------------------
01/29/19 100 Neptune Underwater Supply 1001 500.00 Y CJ0034 1
01/29/19 300 Beverly Beauty Supply *Cash* 250.00 Y CJ0034 1
Date total: 750.00
01/30/19 30 W.J. Bjornfreg A/G 1359 5,000.00 Y CJ0034 1
03/10/19 100 Neptune Underwater Supply 201 140.00 Y 125-6992 CJ0091 1
03/12/19 200 21st Century Enterprises 348 1,500.00 N 125-6992 CJ0091 1
03/12/19 200 21st Century Enterprises 349 500.00 Y 125-6992 CJ0091 1
03/12/19 300 Beverly Beauty Supply 349 1,500.00 Y 125-6992 CJ0091 1
Date total: 3,500.00
03/26/19 600 Ariel Enterprises 5566 150.00 Y 125-6992 CJ0094 1
03/26/19 600 Ariel Enterprises 5566 150.00- Y 125-6992 CJ0103 1
Date total: .00
Grand total: 9,390.00
-- End of report --
A/R Open Item File Purge Report
Date 04/07/2019 Time 12:02:33 XYZ Company Report #0124 Page 0001
A / R O P E N I T E M F I L E P U R G E R E P O R T
Customer # range: 50 to 300
Purge cut-off date: 04/07/19
Document types: I = invoice P = payment C = credit memo D = debit memo F = finance charge B = balance forward R = returned check
Note: Amount-1 is the amount subject to discount, on doc types I, C, D, B & R; cash receipt amt on type P; fin charge on type F.
Amount-2 is the non-discountable amt on doc types I, C & D; discount allowed on doc type P; and not used for doc types B & F.
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Customer-name
------------------------------------------------------------------------------------------------------------------------------------
300 Beverly Beauty Supply
Doc-# Doc-date Typ Apply-to Due-date Amount-1 Amount-2 Doc-total
1026 1/25/19 I 2/24/19 132.95 9.31 142.26
*CASH* 1/29/19 P 1/29/19 250.00- 2.66- 252.66-
Balance carried forward: 117.05- 6.65 110.40-
Date 04/07/2019 Time 12:02:33 XYZ Company Report #0124 Page 0002
A / R O P E N I T E M F I L E P U R G E R E P O R T
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Customer-name
------------------------------------------------------------------------------------------------------------------------------------
Amount-1 Amount-2 Doc-tot
1 Customers printed Grand totals: 117.05- 110.40-
6.65
-- End of report --
Date 04/07/2019 Time 12:06:21 XYZ Company Report #0125 Page 0001
C U S T O M E R H I S T O R Y
Starting date: “Earliest” Starting customer #: “First”
Ending date: “Latest” Ending customer #: “Last”
For A/R account: “All”
Document types: I = invoice P = payment C = credit memo D = debit memo F = finance charge B = balance forward
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-method Sls rep Contact-1 Phone-1
------------------------------------------------------------------------------------------------------------------------------------
300 Beverly Beauty Supply Bal fwd 23 Angie Peters 213-778-9000
Doc-# Doc-date Typ Due-date Amount-1 Amount-2 P.O.-# Doc-total Terms Reference
1/29/19 P 1/29/19 250.00- 2.66- 252.66-A
*** 110.40- from the document above was retained as a bal fwd document in the open item file ***
1026 1/25/19 I 2/24/19 132.95 9.31 142.26 1 From O/E order: 000040
1 Customers printed
-- End of report --
Date 04/07/2019 Time 12:16:10 XYZ Company Report #0126 Page 0001
P U R G E C U S T O M E R H I S T O R Y
Cut-off date: 3/14/19 Starting customer #: “First”
Ending customer #: “Last”
For A/R account: 1100-000 Accounts receivable
Document types: I = invoice P = payment C = credit memo D = debit memo F = finance charge B = balance forward
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Bal-method Sls rep Contact-1 Phone-1
------------------------------------------------------------------------------------------------------------------------------------
300 Beverly Beauty Supply Bal fwd 23 Angie Peters 213-778-9000
Doc-# Doc-date Typ Due-date Amount-1 Amount-2 P.O.-# Doc-total Terms Reference
1/29/19 P 1/29/19 250.00- 2.66- 252.66-A
*** 110.40- from the document above was retained as a bal fwd document in the open item file ***
1026 1/25/19 I 2/24/19 132.95 9.31 142.26 1 From O/E order: 000040
1 Customers printed
-- End of report --
Date 04/07/2019 Time 12:35:01 XYZ Company Report #0127 Page 0001
I N V O I C E H I S T O R Y B Y C U S T O M E R
Types are: INV = Invoice, CRM = Credit memo
“*” after quantity indicates item was drop shipped.
------------------------------------------------------------------------------------------------------------------------------------
Invc-# Invc-date Typ Cust-# Customer name Group Slmn Recur-# Customer P.O.# Sub acct Job-# Sub-job
Ord/RMA-# Ord-dat Disc-% Ship date F.O.B. Contract # Bill-ref-# Deliver-to Apply-to
Lin# Quantity ---------Item/Service/Note------------------------
Price/unit Line-item-net
------------------------------------------------------------------------------------------------------------------------------------
**************************************************
Customer: 99 Anthony Jones, Inc. *
**************************************************
1023 01/25/19 INV 99 Anthony Jones, Inc. 1 000
37 01/25/19 .000 0 0
====================================================================================================================================
10 Goods 6 4
56.00/EACH 336.00
20 Goods 4 1
55.00/EACH 220.00
Invoice 1023 Total shipped 10 556.00
Customer 99 Total shipped 10 556.00
-- End of report --
Date 05/06/2019 Time 09:45:58 XYZ Company Report #0191 Page 0001
I N V O I C E L I S T
“*” after quantity indicates item is drop shipped.
Bill-ref-#: 4 Cust-#: 10 Harris, Goldberg & Jones Ship to: * SAME AS BILL ADDRESS *
Bill-group: RWA Invc-date: NONE YET 456 W. 7th Street
Bill-type: INVOICE Suite 100
San Diego, CA 92100
Country: USA
Cust-PO-#: Invc-disc-%: 0.000 Ship Date:
Terms: Normal Terms Tax code: metropolitan F.O.B.:
Ship-via: Parcel Post Sales rep: Thomas J. Finch Contract #:
------------------------------------------------------------------------------------------------------------------------------------
Seq# Type Qty-ordered --------------- Item/Service/Note ---------------- Sales acct Commisnbl?
Unit Description-1 Price/unit Lin-item-net
Description-2 Lin-disc-% Unit-cost Txbl?
------------------------------------------------------------------------------------------------------------------------------------
10 Svcs 5 Primary installation 4000-200
Svc#: 1 Unit: HOUR 50.00/HOUR 250.00
0.000% 25.00 Yes
20 Notes Please contact our sales office if you have any
questions.
30 Svcs 4 Survey and estimate 4000-200
Svc#: 3 Unit: HOUR 35.00/HOUR 140.00
0.000% 19.00
40 Svcs 1 1 year service and maintenance 4000-200
Svc#: 2 Unit: / 400.00
0.000% 150.00
4 line items
Invoice total: 790.00
Invoice disc: 0.00
Misc charges: 0.00
Freight: 0.00
Sales tax: 20.00 Taxable: 250.00
Total billed: 810.00 Commisnbl: 0.00 Commis amt: 0.00
Tax rate-1 15.00 Tax rate-2 5.00
Date 05/06/2019 Time 09:45:58 XYZ Company Report #0191 Page 0002
I N V O I C E L I S T
1 Invoice with 4 line items Total amount of Invoices: 790.00
Sales tax: 20.00 Taxable: 250.00
Total amount Billed: 810.00 Commisnbl: 0.00
-- End of report --
Date 05/06/2019 Time 10:15:19 XYZ Company Report #0192 Page 0001
S A L E S J O U R N A L
Sales entries are printed in document number order
Current period end date: 1/31/19
Document types: CR = credit memo, DR = debit memo, FIN = finance charge, INVC = invoice
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Doc-# Tx-Cd Apply-to Sale-amt Freight Total-amt P.O.-#
Doc-type Reference Doc-date Terms Due-date Misc-chgs Sales-Tax Cost Sls-rep Commission
------------------------------------------------------------------------------------------------------------------------------------
10 Harris, Goldberg & Jones 100 MCT 790.00 0.00 810.00
INVC Ref #: 000004 05/06/19 A 06/05/19 0.00 20.00 351.00 1 0.00
Automatic distributions: 2220-000 City sales taxes payable 15.00
2230-000 Out of state misc. sales 5.00
Optional distributions: 4000-200 Sales - misc. items 790.00
Date 05/06/2019 Time 10:15:19 XYZ Company Report #0192 Page 0002
S A L E S J O U R N A L
Grand totals
------------------------------------------------------------------------------------------------------------------------------------
Sale-amt Freight Total-amt
Misc-chgs Sales-Tax Cost Commission
------------------------------------------------------------------------------------------------------------------------------------
1 entries Grand totals: 790.00 0.00 810.00
0.00 20.00 351.00 0.00
Acct-# Description Debits Credits
Distribution summary: 1100-000 Accounts receivable 810.00 .00
2220-000 City sales taxes payable .00 15.00
2230-000 Out of state misc. sales .00 5.00
4000-200 Sales - misc. items .00 790.00
-------------------------------------------
Totals: 810.00 810.00
**** One or more entries are dated beyond the current period ending date ****
**** Please be sure to run Period/Year End Closing at your earliest opportunity ****
-- End of report --